/* ================================ */
/* Database name: LIBRARY ' */ /* DBMS name: Microsoft SQL Server 6.x */
/* Created on: 06.10.00 18:56 */
/* ================================ */
/* Database name: LIBRARY */
/* ================================ */
use LIBRARY
go
/* ================================ */
/* Table: BOOKS */
/* ================================ */
create table BOOKS
(
ISBN |
varchar(14) |
not null . |
||
TITLE |
varchar(255) |
not null . |
||
AUTOR |
varchar(30) |
null. |
||
COAUTOR |
varchar(30) |
null. |
||
PUBLICHER |
varchar(30) |
null. |
||
WHERE_PUBLICH varchar(30) null,
YEAR_IZD smallint not null
constraint CKC_YEAR_IZD_BOOKS check
(
YEAR_PUBL >- 1969 AND YEAR_PUBL <= YEAR(GetDate())).
PAGES smallint not null
constraint CKC_PAGES_BOOKS check
(
PAGES between 5 and 1000).
constraint PK_BOOKS primary key (ISBN).
constraint CKT_BOOKS check
(
(AUTOR IS NOT NULL OR (AUTOR IS NULL AND COAUTOR IS NULL))) ) go
/* Table: READERS */
create table READERS