umc_workbook
Tables (8)
book (책)
- Key — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR — NOT NULL
- description (Field2) — TEXT
- category_Key (Key2) — Foreign key → category.Key — NOT NULL
- hastagKey (Key4) — Foreign key → hash_tag.Key — NOT NULL
- lend_status (Field3)
category (Untitled)
- Key — Primary key — NOT NULL
- genre (Field) — VARCHAR — NOT NULL
category_num (Untitled4)
- Key — Foreign key → category.Key — NOT NULL
- num (개수)
hash_tag (Untitled2)
- Key — Primary key — NOT NULL
- Field
- book_Key (Key2) — BIGINT — Foreign key → book.Key — NOT NULL
like (Untitled3)
- uesr_key (Key) — BIGINT — Foreign key → user.Key — NOT NULL
- book_key (Key2) — BIGINT — Foreign key → book.Key — NOT NULL
rent_book (Untitled5)
- Key3 — Primary key — NOT NULL
- user_Key (Key) — BIGINT — Foreign key → user.Key — NOT NULL
- book_Key (Key2) — BIGINT — Foreign key → book.Key — NOT NULL
- date (Field) — DATE
return_alarm (Untitled6)
- Key — Primary key — NOT NULL
- lend_book_Key3 (Key3) — Foreign key → rent_book.Key3 — NOT NULL
- status (Field)
- user_Key (Key2) — BIGINT — Foreign key → user.Key — NOT NULL
user (사용자)
- Key — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR — NOT NULL
- nickname (Field2) — VARCHAR
- phonenumber (Field3)
- gender (Field4)
- status (Field5) — BOOLEAN — NOT NULL