도서대여관리 수정

테이블 (5)

activity_log

  • log_id — INT — 기본 키 — NOT NULL
  • employee_id — VARCHAR(10) — 외래 키 — NOT NULL
  • activity_type — VARCHAR(255)
  • activity_time — DATETIME

book

  • book_id — VARCHAR(10) — 기본 키 — NOT NULL
  • book_title — VARCHAR(255)
  • publisher — VARCHAR(255)
  • author — VARCHAR(255)
  • genre — VARCHAR(255)
  • rental_fee — INT
  • rental_period — INT
  • overdue_fee — INT

employee

  • employee_id — VARCHAR(10) — 기본 키 — NOT NULL
  • name — VARCHAR(255)
  • phone — VARCHAR(20)
  • address — VARCHAR(255)
  • password — VARCHAR(255)
  • is_admin — BOOLEAN

member

  • member_id — VARCHAR(10) — 기본 키 — NOT NULL
  • name — VARCHAR(255)
  • phone — VARCHAR(20)
  • address — VARCHAR(255)
  • mileage — INT
  • rental_books — VARCHAR(255)
  • password — VARCHAR(255)

rental

  • book_id — VARCHAR(10) — 외래 키 — NOT NULL
  • member_id — VARCHAR(10) — 외래 키 — NOT NULL
  • rental_date — DATE
  • return_date — DATE
  • rental_status — VARCHAR(20)