HOME_PHON IS NOT NULL OR
(
NUM_READER intnot null.
NAME varchar(30) not null.
BIRTH_DAY datetime not null
constraint CKC_BIRTH_DAY_READERS check
(
(DateDiffCyear. GetDate().BIRTH_DAY) >=17 )
),
SEX chard) not null
constraint CKC_SEX_READERS check
(
SEX in СМ'.'1'.'м'.'ж')).
HOME_PHON char(9) null.
WORK_PHON char(9) null,
constraint PK_READERS primary key (NUM_READER).
constraint CKT_READERS check
(
( HOME_PHON IS NOT NULL OR WORK_PHON IS NOT NULL))
)
go
/* Table: CATALOG */
/* ================================ */
create table CATALOG
( KW KOD smallint not null.
NAME_KW varchar(255) null, constraint PK_CATALOG primary key (KW_KOD)
)
go
/* ================================ */
/* Table: EXEMPLAR */
create table EXEMPLAR
(
|
INVJUMER |
int not |
null. |
||
|
ISBN |
varchar(14) |
not null . |
||
|
NUM_READER |
int |
null. |
||
|
PRESENT |
bit not |
null. |
||
|
DATE_IN |
datetime |
null. |
||
|
DATE OUT |
datetime |
null. |
||
go
/* ================================ */
/* Index: RELATION_43_FK ' . */ /*
/* ================================ */
create index RELATION_43_FK on EXEMPLAR (ISBN) .
go
/* Index: RELATION_44_FK */
/* ================================ */
create index RELATION_44_FK on EXEMPLAR (NUM_READER) go
/* ================================ */
/* Table: RELATION_67 */
/* ================================ */
create table RELATION_67
(
ISBN varchar(14) not null, KW_KOD smallint not null, constraint
PK_RELATION_67 primary key (ISBN, KW_KOD)
)
go
/* ================================ */
/* Index: IOIINEONY_E_IAEANOE_CIAIEE_FK */
/* ================================ */
create index IOIINEONY_E_IAEANOE_CIAIEE_FK on RELATION_67 (ISBN) go
/* ================================ */
/* Index: I_AANOAAEAIA_A_EIEAAO_FK */
create index I_AANOAAEAIA_A_EIEAAO_FK on RELATION_67 (KW_KOD)
go
alter table EXEMPLAR
add constraint FK_EXEMPLAR_RELATION_BOOKS foreign key (ISBN)
