UMC_1week_mission
Tables (9)
OAuth Provider (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
food_category (Untitled2)
- id (Key) — int — Primary key — NOT NULL
- name (Field) — enum
member (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- gender (Field2) — varchar(10)
- bdate (Field3) — date
- address (Field4) — varchar(100)
- created_at (Field5) — datetime(6)
- updated_at (Field6) — datetime(6)
member_food (Untitled3)
- food_id (Key) — int — Foreign key → food_category.id — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
mission (Untitled6)
- id (Key) — bigint — Primary key — NOT NULL
- title (Field) — varchar(20)
- description (Field2) — varchar(50)
- point (Field3) — int
- status (Field4) — enum
region (Untitled9)
- id (Key) — bigint — Primary key — NOT NULL
- store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
review (Untitled8)
- id (Key) — bigint — Primary key — NOT NULL
- member_id (Key2) — bigint — Foreign key → member.id — NOT NULL
- store_id (Key3) — bigint — Foreign key → store.id — NOT NULL
- visit_date (Field) — date
- content (Field2) — varchar(100)
- star (Field3) — int
store (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(20)
- Address (Field2) — varchar(100)
- category (Field3) — enum
user_oauth (Untitled5)
- id (Key) — bigint — Primary key — NOT NULL
- provider_id (Key2) — bigint — Foreign key → OAuth Provider.id — NOT NULL
- member_id (Key3) — bigint — Foreign key → member.id — NOT NULL
- created_at (Field) — datetime(6)