- 论坛徽章:
- 0
|
--======================================
--Create table:
--Set default:
--Register table:
--======================================
--Create table:
create table t0
(
tab_name varchar(10),
tab_content varchar(100) not null,
primary key(tab_name)
);
--Set defaule:
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't0',
'Table-Informations'
);
--======================================
--Create table:
create table t1
(
dbid int,
level int not null,
login varchar(50) not null,
passwd varchar(50) not null,
primary key(dbid)
);
--Set defaule:
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't1',
'Basic-Register-Informations'
);
--======================================
--Create table:
create table t2
(
dbid int references t1(dbid),
name varchar(50),
birth_date varchar(50),
primary key(dbid)
);
--Set defaule:
alter table t2 alter column name set default 'Timid-Noname';
alter table t2 alter column birth_date set default '0001-01-01';
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't2',
'BAGUA-Informations'
);
--======================================
--Create table:
create table t3
(
dbid int references t1(dbid),
stu_num varchar(50),
primary key(dbid)
);
--Set default:
alter table t3 alter column stu_num set default '0';
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't3',
'Student-Information'
);
--======================================
--Create table:
create table t4
(
sub_num varchar(50),
sub_type varchar(50),
sub_name varchar(50),
sub_time varchar(50),
primary key (sub_num)
);
--Set default:
alter table t4 alter column sub_type set default 'Unknown';
alter table t4 alter column sub_name set default 'Useless-Noname';
alter table t4 alter column sub_time set default '0';
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't4',
'Subject-Information'
);
--======================================
--Create table:
create table t5
(
sub_num varchar(50) references t4(sub_num),
before_sub_num varchar(50) references t4(sub_num),
primary key (sub_num,before_sub_num)
);
--Set default:
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't5',
'Subject-Relation'
);
--======================================
--Create table:
create table t6
(
exam_num varchar(50),
sub_num varchar(50) references t4(sub_num),
exam_time varchar(50),
exam_content varchar(100),
primary key (exam_num)
);
--Set default:
alter table t6 alter column exam_time set default '0001-01-01';
alter table t6 alter column exam_content set default 'Unknown';
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't6',
'Examination-Information'
);
--======================================
--Create table:
create table t7
(
dbid int references t1(dbid),
exam_num varchar(50) references t6(exam_num),
score varchar(50),
primary key(dbid,exam_num)
);
--Set default:
alter table t7 alter column score set default '0';
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't7',
'Student-Score'
);
--======================================
--Create table:
create table t8
(
dbid int references t1(dbid),
tea_num varchar(50),
primary key(dbid)
);
--Set default:
alter table t8 alter column tea_num set default '0';
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't8',
'Teacher-Information'
);
--======================================
--Create table:
create table t9
(
dbid int references t1(dbid),
sub_num varchar(50) references t4(sub_num),
primary key (dbid,sub_num)
);
--Set default:
--Register table:
insert into t0
(
tab_name,
tab_content
)
values
(
't9',
'Teacher-Subject'
);
--====================================== |
|