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