-- auto-generated definition
create table admin
(
    account  nvarchar(20) not null
        constraint admin_pk
            primary key,
    password nvarchar(20)
)
go


-- auto-generated definition
create table book
(
    book_id      nvarchar(20) primary key,
    name         nvarchar(20),
    author       nvarchar(20),
    publisher    nvarchar(20),
    publish_date date,
    price        float,
    summary      nvarchar(50),
    is_borrowed  bit
)
go

create table reader
(
    id       int identity
        constraint reader_pk
            primary key,
    name     nvarchar(20),
    gender   tinyint,
    unit     nvarchar(20),
    tel      nvarchar(20),
    balance  float,
    password nvarchar(20)
)
go

create table role
(
    id                int identity
        constraint role_pk
            primary key,
    name              varchar(20),
    borrow_num_limit  int,
    borrow_date_limit int
)
go

create table reader_role
(
    reader_id int not null
        constraint reader_role_pk
            primary key
        constraint reader_role_reader_id_fk
            references reader,
    role_id   int
        constraint reader_role_role_id_fk
            references role
)
go

create table borrow
(
    id            int identity
        constraint borrow_pk
            primary key,
    reader_id     int
        constraint borrow_reader_id_fk
            references reader,
    book_id       int
        constraint borrow_book_id_fk
            references book,
    borrow_date   datetime,
    return_date   datetime,
    is_overdue    bit,
    overdue_money float,
    is_process    bit
)
go


exec sp_addextendedproperty 'MS_Description', '����Ա', 'SCHEMA', 'dbo', 'TABLE', 'admin'
go

exec sp_addextendedproperty 'MS_Description', '����Ա�˻�', 'SCHEMA', 'dbo', 'TABLE', 'admin', 'COLUMN', 'account'
go

exec sp_addextendedproperty 'MS_Description', '����', 'SCHEMA', 'dbo', 'TABLE', 'admin', 'COLUMN', 'password'
go


exec sp_addextendedproperty 'MS_Description', 'ͼ���', 'SCHEMA', 'dbo', 'TABLE', 'book'
go

exec sp_addextendedproperty 'MS_Description', '����id', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'id'
go

exec sp_addextendedproperty 'MS_Description', 'ͼ����', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'book_id'
go

exec sp_addextendedproperty 'MS_Description', '����', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'name'
go

exec sp_addextendedproperty 'MS_Description', '����', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'author'
go

exec sp_addextendedproperty 'MS_Description', '������', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'publisher'
go

exec sp_addextendedproperty 'MS_Description', '��������', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'publish_date'
go

exec sp_addextendedproperty 'MS_Description', '����', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'price'
go

exec sp_addextendedproperty 'MS_Description', '���', 'SCHEMA', 'dbo', 'TABLE', 'book', 'COLUMN', 'summary'
go

-- auto-generated definition


exec sp_addextendedproperty 'MS_Description', '���ı�', 'SCHEMA', 'dbo', 'TABLE', 'borrow'
go

exec sp_addextendedproperty 'MS_Description', '�Ƿ�����', 'SCHEMA', 'dbo', 'TABLE', 'borrow', 'COLUMN', 'is_overdue'
go

exec sp_addextendedproperty 'MS_Description', '���ڽ��', 'SCHEMA', 'dbo', 'TABLE', 'borrow', 'COLUMN', 'overdue_money'
go

exec sp_addextendedproperty 'MS_Description', '�����Ƿ���', 'SCHEMA', 'dbo', 'TABLE', 'borrow', 'COLUMN', 'is_process'
go


exec sp_addextendedproperty 'MS_Description', '1���У�0��Ů', 'SCHEMA', 'dbo', 'TABLE', 'reader', 'COLUMN', 'gender'
go

exec sp_addextendedproperty 'MS_Description', '��λ', 'SCHEMA', 'dbo', 'TABLE', 'reader', 'COLUMN', 'unit'
go

exec sp_addextendedproperty 'MS_Description', '���', 'SCHEMA', 'dbo', 'TABLE', 'reader', 'COLUMN', 'balance'
go

-- auto-generated definition


exec sp_addextendedproperty 'MS_Description', '��������', 'SCHEMA', 'dbo', 'TABLE', 'reader_role'
go

-- auto-generated definition


exec sp_addextendedproperty 'MS_Description', '��������', 'SCHEMA', 'dbo', 'TABLE', 'role'
go

exec sp_addextendedproperty 'MS_Description', '����������', 'SCHEMA', 'dbo', 'TABLE', 'role', 'COLUMN', 'borrow_num_limit'
go

exec sp_addextendedproperty 'MS_Description', '���������', 'SCHEMA', 'dbo', 'TABLE', 'role', 'COLUMN', 'borrow_date_limit'
go