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)