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