ㅁㄴㅇㅁ

Tables (9)

admin_board

  • id — BIGINT — Primary key — NOT NULL
  • type — varchar(20) — NOT NULL
  • created_date — timestamp — NOT NULL
  • updated_date — timestamp — NOT NULL
  • publish_end_date — timestamp
  • title — varchar(255) — NOT NULL
  • content — varchar — NOT NULL
  • attached_file_name — varchar(255)
  • attached_file — varchar
  • user_id — BIGINT — NOT NULL

book

  • id — BIGINT — Primary key — NOT NULL
  • title — varchar(255) — NOT NULL
  • author — varchar(255) — NOT NULL
  • isbn — varchar(100) — NOT NULL
  • cover — varchar
  • publish_date — timestamp — NOT NULL
  • sub_title — varchar
  • created_date — timestamp — NOT NULL
  • updated_date — timestamp — NOT NULL
  • summary — varchar

book_item

  • id — BIGINT — Primary key — NOT NULL
  • book_info_id — BIGINT — NOT NULL
  • status — varchar(10) — NOT NULL
  • book_code — varchar(20) — NOT NULL

book_reserve

  • id — BIGINT — Primary key — NOT NULL
  • created_date — timestamp — NOT NULL
  • end_date — timestamp — NOT NULL
  • status — varchar(10) — NOT NULL — 정상 완료
  • book_Id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

book_review

  • id — BIGINT — Primary key — NOT NULL
  • score — INT — NOT NULL
  • content — varchar
  • writer — varchar(100) — NOT NULL
  • created_date — timestamp — NOT NULL
  • update_date — timestamp — NOT NULL
  • user_id — BIGINT — NOT NULL
  • Key — VARCHAR(255) — NOT NULL

password

  • id — BIGINT — Foreign key → user.id
  • password — varchar — NOT NULL

rent

  • id — BIGINT — Primary key — NOT NULL
  • start_date — timestamp — NOT NULL
  • end_date — timestamp — NOT NULL
  • status — varchar(10) — NOT NULL — 정상 완료 연체
  • book_id — BIGINT — NOT NULL
  • user_id — BIGINT — NOT NULL

user

  • id — BIGINT
  • email — varchar(255) — NOT NULL
  • name — varchar(255) — NOT NULL
  • phone — varchar(255) — NOT NULL

user_board

  • id — BIGINT — Primary key — NOT NULL
  • type — varchar(20) — NOT NULL — 사용자 게시글의 타입 문의 자유글
  • created_date — timestamp — NOT NULL
  • updated_date — timestamp — NOT NULL
  • title — varchar(255) — NOT NULL
  • content — varchar — NOT NULL
  • attached_file_name — varchar(255)
  • attached_file — varchar
  • user_id — BIGINT — NOT NULL