12312
Tables (6)
AUTHOR
- author_id — bigint — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- country — varchar(50)
- created_date — timestamp — NOT NULL
- modified_date — timestamp — NOT NULL
BOOK
- book_id — bigint — Primary key — NOT NULL
- ISBN — varchar(30) — NOT NULL
- name — varchar(50) — NOT NULL
- description — varchar(100)
- status — varchar(10) — NOT NULL — 대여중,대여가능
- file_format — varchar(20)
- download_status — boolean — NOT NULL
- author_id — bigint — NOT NULL
- category_id — bigint — NOT NULL
- created_date — timestamp — NOT NULL
- modified_date — timestamp — NOT NULL
CATEGORY
- category_id — bigint — Primary key — NOT NULL
- contents — varchar(100) — NOT NULL
RENT
- rent_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → USER.user_id — NOT NULL
- book_id — bigint — Foreign key → BOOK.book_id — NOT NULL
- rent_date — timestamp
- return_date — timestamp
- due_date — timestamp
- extension — timestamp
- created_date — timestamp — NOT NULL
- modified_date — timestamp — NOT NULL
REQUEST
- request_id — bigint — Primary key — NOT NULL
- user_id — bigint — Foreign key → USER.user_id — NOT NULL
- book_name — varchar(50) — NOT NULL
- status — varchar(20) — NOT NULL — 대기중,승인됨,불허
- request_date — timestamp
- created_date — timestamp — NOT NULL
- modified_date — timestamp — NOT NULL
- book_id — bigint(30)
USER
- user_id — bigint — Primary key — NOT NULL
- ID — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
- phone_number — varchar(11) — NOT NULL
- grade — varchar(100) — NOT NULL — 학생,교직원
- univ — varchar(100) — NOT NULL
- rent_count — int
- created_date — timestamp — NOT NULL
- modified_date — timestamp — NOT NULL