|
SELECT COUNT(*) FROM USER_TAB_COLUMNS WHERE TABLE_NAME=UPPER(''''legalentity'''') MYSQL中的外键： /*==============================================================*/
/* DBMS name: MySQL 4.0 */
/* Created on: 2005-8-9 16:38:37 */
/*==============================================================*/
drop table if exists Article;
drop table if exists Board; drop table if exists User; /*==============================================================*/
/* Table: Article */
/*==============================================================*/
create table Article
(
id int not null primary key,
parent_id int,
index(parent_id),
foreign key (parent_id) references Article (id) ,
board_id int not null,
index(board_id),
foreign key (board_id) references Board (id) ,
article_type int not null,
title varchar(255) not null,
body text,
create_by int not null,
index(create_by),
foreign key (create_by) references User (id) ,
create_time datetime not null,
hits int not null,
bytes int,
last_update_by int not null,
index(last_update_by),
foreign key (last_update_by) references User (id),
last_update_time datetime not null,
)
type = InnoDB; /*==============================================================*/
/* Table: Board */
/*==============================================================*/
create table Board
(
id int not null primary key,
create_by int not null,
index(create_by),
foreign key (create_by) references User (id),
parent_id int,
index(parent_id),
foreign key (parent_id) references Board (id),
name varchar(50) not null,
remark varchar(255),
create_time datetime not null,
)
type = InnoDB; /*==============================================================*/
/* Table: User * [1] [2] 下一页
[办公软件]在sybase中插入图片、PDF、文本文件 [办公软件]安装Sybase ASE
[办公软件]linux指令大全(完整篇) [办公软件]Linux新手入门常用命令大全
[办公软件]在RedHat Linux 9里安装gaim0.80 [办公软件]浅谈Linux 下Java 1.5 汉字方块问题解决方法
[办公软件]Linux程序员必读：中文化与GB18030标准 [办公软件]linux指令大全
[办公软件]制作Linux启动盘的四种方法 [办公软件]Linux文件系统的反删除方法
|
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
