test

Tables (8)

Book (Untitled)

  • bood_id (bigint) — bigint — Primary key — NOT NULL
  • id (Key) — bigint — Foreign key → bookCategory.id — NOT NULL
  • name (varchar(40)) — varchar(40)
  • description (Field2) — text
  • created_at (Field3) — datetime(6)
  • updated_at (Field4) — datetime(6)

Like (Untitled4)

  • Key — Foreign key → Book.bood_id — NOT NULL
  • member_id (Key2) — varchar(15) — Foreign key → member.phone_num — NOT NULL
  • id (Key3) — bigint — Foreign key → Book.id — NOT NULL
  • created_at (Field)
  • updated_at (Field2)

alarm (Untitled8)

  • id (Key) — Primary key — NOT NULL
  • user_id (Key2) — varchar(15) — Foreign key → member.phone_num — NOT NULL
  • is_confirmed (Field)
  • created_at (Field2)
  • updated_at (Field3)
  • dtype (Field4)
  • title (Field5)
  • body (Field6)

bookCategory (Untitled5)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar(20)
  • created_at (Field2) — datetime(6)
  • updated_at (Field3) — datetime(6)

hashtag (Untitled7)

  • tag_id (Key) — Primary key — NOT NULL
  • tag_name (Field)
  • created_at (Field2)
  • updated_at (Field3)

hashtag_book (Untitled3)

  • Key (Key2) — Foreign key → Book.bood_id — NOT NULL
  • tag_id (Key) — Foreign key → hashtag.tag_id — NOT NULL
  • id (Key3) — bigint — Foreign key → Book.id — NOT NULL
  • tagname (Field)

member (Untitled2)

  • phone_num (Key) — varchar(15) — Primary key — NOT NULL
  • name (Field) — varchar(10)
  • nickname (Field2) — varchar(20)
  • gender (Field4) — varchar(10)
  • created_at (Field5) — datetime(6)
  • updated_at (Field6) — datetime(6)
  • status (Field3)
  • inactive_date (Field7)

rent (Untitled6)

  • id (Key) — Primary key — NOT NULL
  • book_id (bigint) — bigint — Foreign key → Book.bood_id — NOT NULL
  • member_id (Key2) — varchar(15) — Foreign key → member.phone_num — NOT NULL
  • id (Key3) — bigint — Foreign key → Book.id — NOT NULL
  • created_at (Field) — datetime(6)
  • updated_at (Field2) — datetime(6)