UMC_1주차
테이블 (6)
favor_food_category (Untitled2)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → food_category.Key — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field2 (updated_at) — DATETIME — NOT NULL
- Key (food_category_id) — bigint — 외래 키 → user.Key — NOT NULL
food_category (Untitled6)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (updated_at) — DATETIME — NOT NULL
- Field (name) — varchar(50) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
mission (Untitled4)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (title) — varchar(100) — NOT NULL
- Field2 (point) — int — NOT NULL
- Field (status) — varchar(50) — NOT NULL
- Field2 (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
- Key (restraurant_id) — bigint — 외래 키 → mission.Key — NOT NULL
- Key (id2) — bigint — 외래 키 → restaurant.Key — NOT NULL
restaurant (Untitled3)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (name) — varchar(50) — NOT NULL
- Field (region) — varchar(50) — NOT NULL
- Field (address) — varchar(255) — NOT NULL
- Field (created_at) — datetime — NOT NULL
- Field (updated_at) — datetime — NOT NULL
- Key (food_category_id) — bigint — 외래 키 → restaurant.Key — NOT NULL
- Key (id2) — bigint — 외래 키 → food_category.Key — NOT NULL
user (Untitled)
- Key (id) — bigint — 기본 키 — NOT NULL
- Field (email) — VARCHAR(50) — NOT NULL
- Field (password) — VARCHAR(50) — NOT NULL
- Field (phone_number) — VARCHAR(50) — NOT NULL
- Field (status) — VARCHAR(50) — NOT NULL
- Field (created_at) — DATETIME — NOT NULL
- Field (updated_at) — DATETIME — NOT NULL
user_mission (Untitled5)
- Key (id) — bigint — 기본 키 — NOT NULL
- Key (user_id) — bigint — 외래 키 → user.Key — NOT NULL
- Field (completed_at) — varchar(50)
- Field (created_at) — datetime — NOT NULL
- Key (mission_id) — bigint — 외래 키 → mission.Key — NOT NULL