serteasr
Tables (7)
book
- id — BIGINT
- book_category_id — BIGINT — Foreign key → book_category.id
- name — VARCHAR(40)
- description — TEXT
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
book_category
- id — BIGINT
- name — VARCHAR(20)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
book_hash_tag
- id — BIGINT
- book_id — BIGINT — Foreign key → book.id
- hash_tag_id — BIGINT — Foreign key → hash_tag.id
book_likes
- id — BIGINT
- book_id — BIGINT — Foreign key → book.id
- member_id — BIGINT — Foreign key → member.id
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
hash_tag
- id — BIGINT
- name — VARCHAR(20)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
member
- id — BIGINT
- phone_num — VARCHAR(15)
- name — VARCHAR(10)
- nickname — VARCHAR(20)
- gender — VARCHAR(10)
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- status — VARCHAR(15)
- inactive_date — DATETIME
rent
- id — BIGINT
- book_id — BIGINT — Foreign key → book.id
- member_id — BIGINT — Foreign key → member.id
- created_at — DATETIME(6)
- updated_at — DATETIME(6)