book
Tables (10)
book (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- book_category_id (Key2) — BIGINT — Foreign key → book_category.id — NOT NULL
- title (Field) — VARCHAR(255)
- description (Field2) — TEXT
- created_at (Field4) — DATETIME(6)
- update_at (Field5) — DATETIME(6)
book_category (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- created_at (Field2) — DATETIME(6)
- update_at (Field3) — DATETIME(6)
book_hash_tag (Untitled6)
- id (Key) — BIGINT — Primary key — NOT NULL
- book_id (Key2) — BIGINT — Foreign key → book.id — NOT NULL
- hash_tag_id (Key3) — BIGINT — Foreign key → hash_tag.id — NOT NULL
book_like (Untitled7)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL
- book_id (Key3) — BIGINT — Foreign key → book.id — NOT NULL
- created_at (Field) — DATETIME(6)
- update_at (Field2) — DATETIME(6)
hash_tag (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- created_at (Field2) — DATETIME(6)
- update_at (Field3) — DATETIME(6)
member (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- nickname (Field2) — VARCHAR(50)
- phone_num (Field3) — VARCHAR(20)
- gender (Field4) — VARCHAR(10)
- status (Field5) — VARCHAR(15)
- inactive_date (Field6) — DATETIME NULL
- created_at (Field7) — DATETIME(6)
- update_at (Field8) — DATETIME(6)
member_social_account (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL
- provider (Field) — VARCHAR(20)
- provider_user_id (Field2) — VARCHAR(100)
- created_at (Field3) — DATETIME(6)
notice (Untitled9)
- id (Key) — BIGINT — Primary key — NOT NULL
- title (Field) — VARCHAR(100)
- body (Field2) — TEXT
- created_at (Field3) — DATETIME(6)
- update_at (Field4) — DATETIME(6)
notification (Untitled10)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL
- notice_id (Key3) — BIGINT — Foreign key → notice.id — NOT NULL
- rent_id (Key4) — BIGINT — Foreign key → rent.id — NOT NULL
- type (Field) — VARCHAR(20)
- title (Field2) — VARCHAR(100)
- body (Field3) — TEXT
- is_confirmed (Field4) — BOOLEAN
- created_at (Field5) — DATETIME(6)
- update_at (Field6) — DATETIME(6)
rent (Untitled8)
- id (Key) — BIGINT — Primary key — NOT NULL
- member_id (Key2) — BIGINT — Foreign key → member.id — NOT NULL
- book_id (Key3) — BIGINT — Foreign key → book.id — NOT NULL
- rented_at (Field) — DATETIME(6)
- due_at (Field2) — DATETIME(6)
- returned_at (Field3) — DATETIME(6) NULL
- status (Field4) — VARCHAR(20)
- created_at (Field5) — DATETIME(6)
- update_at (Field6) — DATETIME(6)