UMC_ERD_1주차미션2

테이블 (7)

category (CopyOfUntitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

member (CopyOfUntitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

member_prefer (CopyOfUntitled4)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • category_id (Key3) — bigint — 외래 키 → category.id — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

mission (Untitled2)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • store_id (Key2) — bigint — 외래 키 → store.id — NOT NULL
  • region_id (Key22) — bigint — 외래 키 → store.region_id — NOT NULL
  • category_id (Key3) — bigint — 외래 키 → store.category_id — NOT NULL
  • Field

region (Untitled)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime

review (CopyOfUntitled22)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
  • Field

store (CopyOfUntitled3)

  • id (Key) — bigint — 기본 키 — NOT NULL
  • region_id (Key2) — bigint — 외래 키 → region.id — NOT NULL
  • category_id (Key3) — bigint — 외래 키 → category.id — NOT NULL
  • created_at (Field) — datetime
  • updated_at (Field2) — datetime