UMC11th
Tables (8)
Member (사용자)
- id (Key) — Auto Increment — Primary key — NOT NULL
- gender (Field2) — ENUM
- name (Field) — VARCHAR
- birth (Field3) — VARCHAR
- email (Field8) — VARCHAR
- address (Field4) — VARCHAR
- created_at (Field5) — DATETIME
- updated_at (Field6) — DATETIME
- deleted_at (Field7) — DATETIME
Member_Auth (소셜 로그인)
- id (Key) — Auto Increment — Primary key — NOT NULL
- user_id (Key2) — Auto Increment — Foreign key → Member.id — NOT NULL
- provider (Field) — VARCHAR
- provider_id (Field2) — VARCHAR
Region (지역)
- id (Key) — Auto Increment — Primary key — NOT NULL
- name (Field) — VARCHAR
Store (가게)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (가계 이름) — VARCHAR
- regionId (Key2) — BIGINT — Foreign key → Region.id — NOT NULL
- categoryId (Key3) — BIGINT — Foreign key → food_category.id — NOT NULL
food_category (음식 종류)
- id (Key) — Auto Increment — Primary key — NOT NULL
- name (음식 이름) — VARCHAR
member_mission (사용자 미션)
- id (Key) — Auto Increment — Primary key — NOT NULL
- userId (Key2) — BIGINT — Foreign key → Member.id — NOT NULL
- missionId (Key3) — BIGINT — Foreign key → mission.id — NOT NULL
- status (미션 상태) — VARCHAR
mission (미션)
- id (Key) — Auto Increment — Primary key — NOT NULL
- title (미션 제목) — VARCHAR
- content (미션 내용) — VARCHAR
store_mission (가게 미션)
- id (Key) — Auto Increment — Primary key — NOT NULL
- id (Key3) — BIGINT — Foreign key → mission.id — NOT NULL
- id (Key2) — BIGINT — Foreign key → Store.id — NOT NULL