umc_11th_week 1
Tables (8)
book
- id — BIGINT — Primary key — NOT NULL
- category_id — BIGINT — Foreign key → category.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
book_hashtag
- id — BIGINT — Primary key — NOT NULL
- book_id — BIGINT — Foreign key → book.id — NOT NULL
- hashtag_id — BIGINT — Foreign key → hashtag.id — NOT NULL
book_like
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- book_id — BIGINT — Foreign key → book.id — NOT NULL
- created_at — DATETIME — NOT NULL
category
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
hashtag
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
member
- id — BIGINT — Primary key — NOT NULL
- kakao_id — VARCHAR(100) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- phone_number — VARCHAR(20) — NOT NULL
- gender — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
notification
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- title — VARCHAR(100) — NOT NULL
- content — TEXT — NOT NULL
- is_read — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
rental
- id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.id — NOT NULL
- book_id — BIGINT — Foreign key → book.id — NOT NULL
- rented_at — DATETIME — NOT NULL
- due_at — DATETIME — NOT NULL
- returned_at — DATETIME