UMC_ERD_1주차미션
테이블 (8)
category (CopyOfCopyOfUntitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20)
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
member (CopyOfCopyOfCopyOfCopyOfUntitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- region_id (Key2) — bigint — 외래 키 → region.id — NOT NULL
- name (Field) — varchar(20)
- gender (Field2) — enum('M','F')
- address (Field3) — varchar(100)
- point (Field4) — int
- status (Field5) — enum('ACTIVE', INACTIVE')
- role (Field7) — enum('CUSTOMER', 'OWNER')
- phone_number (Field8) — int — NOT NULL
- is_phone_verified (Field9) — bool
- email (Field10) — varchar(30)
- created_at (Field6) — datetime
- updated_at (Field11) — datetime
member_mission (CopyOfCopyOfCopyOfUntitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key4) — bigint — 외래 키 → member.id — NOT NULL
- mission_id (Key2) — bigint — 외래 키 → mission.id — NOT NULL
- status (Field) — enum('CHALLENGING', 'COMPLETE', 'FAILED', 'PENDING')
- created_at (Field2) — datetime
- updated_at (Field3) — datetime
member_prefer (Untitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- category_id (Key2) — bigint — 외래 키 → category.id — NOT NULL
- member_id (Key3) — bigint — 외래 키 → member.id — NOT NULL
- created_at (Field) — datetime
- updated_at (Field2) — datetime
mission (CopyOfCopyOfCopyOfUntitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- store_id (Key2) — bigint — 외래 키 → store.id — NOT NULL
- reward (Field2) — int
- deadline (Field) — datetime
- content (Field3) — text
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
region (Untitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(20)
review (CopyOfCopyOfCopyOfCopyOfCopyOfUntitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key2) — bigint — 외래 키 → member.id — NOT NULL
- store_id (Key3) — bigint — 외래 키 → store.id — NOT NULL
- parent_id (Field3) — bigint
- content (Field) — text
- score (Field2) — int
- created_at (Field4) — datetime
- updated_at (Field5) — datetime
store (CopyOfUntitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- member_id (Key4) — bigint — 외래 키 → member.id — NOT NULL
- region_id (Key2) — bigint — 외래 키 → region.id — NOT NULL
- category_id (Key3) — bigint — 외래 키 → category.id — NOT NULL
- name (Field) — varchar(20)
- address (Field2) — varchar(100)
- score (Field3) — int
- created_at (Field4) — datetime
- updated_at (Field5) — datetime