챕터 1

테이블 (12)

aram (CopyOfUntitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • is_confirmed (Field) — varchar(20)
  • created_at (Field2) — datetimr(6)
  • update_at (Field3) — datetimr(6)
  • dtype (Field4) — varchar(40)
  • title (Field5) — varchar(40)
  • body (Field6) — text

book (CopyOf)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • book_category_id (Key2) — bigint — 외래 키 → book_category.id — NOT NULL
  • name (Field) — varchar(40)
  • description (Field2) — text
  • created_at (Field3) — datetimr(6)
  • update_at (Field4) — datetimr(6)

book_category (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(20)
  • created_at (Field2) — datetimr(6)
  • update_at (Field3) — datetimr(6)

book_hash_tag (CopyOfCopyOfCopyOf2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • book_id (Key2) — bigint — 외래 키 → book.id — NOT NULL
  • hash_tag_id (Key3) — bigint — 외래 키 → hash_tag.id — NOT NULL

book_likes (CopyOfCopyOf3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • book_id (Key2) — bigint — 외래 키 → book.id — NOT NULL
  • member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL
  • created_at (Field3) — datetimr(6)
  • update_at (Field4) — datetimr(6)

hash_tag (CopyOfCopyOf2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field) — varchar(40)
  • created_at (Field3) — datetimr(6)
  • update_at (Field4) — datetimr(6)

marketing (CopyOfCopyOfCopyOfCopyOfUntitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field5) — varchar(40)
  • body (Field6) — text

marketing_aram (CopyOfCopyOfCopyOfUntitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • is_confirmed (Field) — varchar(20)
  • created_at (Field2) — datetimr(6)
  • update_at (Field3) — datetimr(6)
  • title (Field5) — varchar(40)
  • body (Field6) — text

member (CopyOfCopyOf)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • phone_num (Field3) — varchar(20)
  • name (Field) — varchar(20)
  • description (Field2) — varchar(20)
  • nickname (Field4) — varchar(20)
  • gender (Field5) — varchar(20)
  • created_at (Field6) — datetimr(6)
  • update_at (Field7) — datetimr(6)
  • status (Field8) — varchar(20)
  • inactive_date (Field9) — datetime

notice (CopyOfCopyOfCopyOfUntitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • title (Field5) — varchar(40)
  • body (Field6) — text

notice_aram (CopyOfCopyOfUntitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • is_confirmed (Field) — varchar(20)
  • created_at (Field2) — datetimr(6)
  • update_at (Field3) — datetimr(6)
  • title (Field5) — varchar(40)
  • body (Field6) — text

rent (CopyOfCopyOfCopyOf3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • book_id (Key2) — bigint — 외래 키 → book.id — NOT NULL
  • member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL
  • created_at (Field3) — datetimr(6)
  • update_at (Field4) — datetimr(6)