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