erd 실습

테이블 (8)

Untitled8

  • id (Key) — bigint — 기본 키 — NOT NULL
  • user_id (Field2) — bigint
  • is_confirmed (Field) — bigint
  • create_at (Field3) — datetime(6)
  • update_at (Field4) — datetime(6)
  • dtype (Field5) — varchar
  • title (Field6) — varchar(30
  • body (Field7)

book (Untitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • description (Field)
  • create_at (Field2) — datetime(6)
  • update_at (Field3) — datetime(6)
  • id (Key2) — bigint — 외래 키 → book_category.id — NOT NULL

book_category (Untitled3)

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

book_hash_tag (Untitled6)

  • id (Key) — bigint — 기본 키 — NOT NULL

book_likes (Untitled5)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • create_at (Field3) — datetime(6)
  • update_at (Field4) — datetime(6)

hash_tag (Untitled7)

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

member (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • name (Field2) — varchar(20)
  • phone_num (Field)
  • nickname (Field3)
  • create_at (Field4) — datetime(6)
  • update_at (Field5) — datetime(6)
  • status (Field6) — varchar
  • inactive (Field7)

rent (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • create_at (Field3) — datetime(6)
  • update_at (Field4) — datetime(6)