UMC
Tables (7)
food_category (Untitled3)
- PK (food_category_id) — BIGINT — Primary key — NOT NULL
- (name) — VARCHAR
- (created_at)
member (Untitled6)
- PK (member_id) — BIGINT — Primary key — NOT NULL
- (email) — VARCHAR
- (name) — VARCHAR
- (point) — INT
- (created_at) — TIMESTAMP
member_mission (Untitled5)
- PK (member_mission_id) — BIGINT — Primary key — NOT NULL
- PK (mission_id2) — BIGINT — Foreign key → mission.PK — NOT NULL
- PK (member_id) — BIGINT — Foreign key → member.PK — NOT NULL
- (status) — VARCHAR
- (completed_at) — TIMESTAMP
mission (Untitled4)
- PK (mission_id) — BIGINT — Primary key — NOT NULL
- (title) — VARCHAR
- (description) — VARCHAR
- (created_at) — TIMESTAMP
region (Untitled)
- PK (region_id) — BIGINT — Primary key — NOT NULL
- (name) — VARCHAR
- (created_at) — TIMESTAMP
social_login (Untitled7)
- PK (social_login_id) — BIGINT — Primary key — NOT NULL
- PK (member_id) — BIGINT — Foreign key → member.PK — NOT NULL
- (provider) — VARCHAR
- (provider_user_id) — VARCHAR
- (created_at) — TIMESTAMP
store (Untitled2)
- PK (store_id) — BIGINT — Primary key — NOT NULL
- PK (region_id) — BIGINT — Foreign key → region.PK — NOT NULL
- PK (food_category_id) — BIGINT — Foreign key → food_category.PK — NOT NULL
- PK (mission_id) — BIGINT — Foreign key → mission.PK — NOT NULL
- (name) — VARCHAR
- (address) — VARCHAR
- (created_at) — TIMESTAMP