DBD final proj

Tables (10)

Current_session (Untitled5)

  • session_id (Key) — Primary key — NOT NULL
  • login_time (Field)
  • user (Field2)

User (Untitled)

  • UserID (Key) — VARCHAR(20) — Primary key — NOT NULL — 같은 id 불가
  • PW (Field) — VARCHAR(20) — NOT NULL
  • name (Field2) — VARCHAR(30) — NOT NULL
  • gender (Field3) — ENUM — NOT NULL

User_manager (CopyOfUntitled2)

  • UserID (Key) — Foreign key → User.UserID — NOT NULL

User_member (CopyOfUntitled)

  • UserID (Key) — Foreign key → User.UserID — NOT NULL
  • is_overdue (Field) — BOOL — NOT NULL — 연체면 대출 불가

author (Untitled8)

  • author_ID (Key) — VARCHAR(10) — Primary key — NOT NULL — NUMBER
  • name (Field) — VARCHAR(30) — NOT NULL
  • country (Field2) — VARCHAR(20) — NOT NULL

book (Untitled3)

  • bookID (Key) — VARCHAR(10) — Primary key — NOT NULL — NUMBER
  • name (Field) — VARCHAR(30) — NOT NULL — index이용
  • gerne_ID (Key2) — Foreign key → gerne.gerne_ID — NOT NULL — delete restrict
  • author_ID (Key3) — Foreign key → author.author_ID — NOT NULL — index, on delete restrict
  • is_borrowed (Field2) — BOOL — NOT NULL — trigger필요

comments (Untitled7)

  • comment (Field) — VARCHAR(100) — loan_history에 대출 기록 있어야 대출 가능
  • bookID (Key) — Foreign key → book.bookID — NOT NULL — on delete cascade
  • UserID (Key2) — Foreign key → User_member.UserID — NOT NULL — on delete cascade

gerne (Untitled4)

  • gerne_ID (Key) — VARCHAR(3) — Primary key — NOT NULL — NUMBER
  • name (Field) — VARCHAR(15) — NOT NULL

loan (Untitled2)

  • when_borrowed (Field2) — DATE — NOT NULL — login 할때, 대출 기한 넘었으면 연체로 바꿈
  • bookID (Key2) — Foreign key → book.bookID — NOT NULL — on delete cascade
  • UserID (Key) — Foreign key → User_member.UserID — NOT NULL — index, on delete restrict

loan_history (Untitled6)

  • when_borrowed (Field2) — DATE — NOT NULL
  • UserID (Key) — Foreign key → User_member.UserID — NOT NULL — index, on delete cascade
  • bookID (Key2) — VARCHAR(10) — Foreign key → book.bookID — NOT NULL — on delete cascade