UMC_5th
Tables (8)
favorite_food (Untitled8)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
- id (Key3) — bigint — Foreign key → food_sort.id — NOT NULL
- sort (Field) — varchar(10)
food_sort (Untitled7)
- id (Key) — bigint — Primary key — NOT NULL
- food_name (Field) — varchar(10)
- Field2
misson (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- id (Key2) — bigint — Foreign key → my_misson.id — NOT NULL
- user_id (Key22) — BIGINT — Foreign key → my_misson.user_id — NOT NULL
- title (Field) — varchar(50)
- content (Field2) — varchar(200)
- status (Field3) — varchar(10)
- num (Field4) — varchar(20)
- point (Field5) — int
- deadline_date (Field6) — datetime
my_misson (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → user.id — NOT NULL
- success (Field) — int
- trying (Field2) — int
- untrying (Field3) — int
question (Untitled6)
- id (Key2) — bigint — Primary key — NOT NULL
- user_id (Key) — BIGINT — Foreign key → user.id — NOT NULL
- title (Field) — varchar(50)
- content (Field2) — varchar(500)
- created_at (Field3) — datetime(6)
- updated_at (Field4) — datetime(6)
- status (Field5) — varchar(15)
review (Untitled5)
- id (Key2) — bigint — Primary key — NOT NULL
- user_id (Key) — BIGINT — Foreign key → user.id — NOT NULL
- store_id (Key3) — bigint — Foreign key → store.id — NOT NULL
- star (Field) — double
- content (Field2) — varchar(1000)
- image (Field3) — varchar(200)
- created_at (Field4) — datetime(6)
- updated_at (Field6) — datetime(6)
store (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- store_name (Field) — varchar(20)
- sort (Field2) — varchar(10)
- region (Field3) — varchar(20)
user (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — varchar(10)
- gender (Field2) — varchar(10)
- address (Field6) — varchar(100)
- birth (Field5) — varchar(20)
- point (Field8) — int
- created_at (Field3) — datetime(6)
- updated_at (Field9) — datetime(6)
- status (Field4) — varchar(15)
- inactive_date (Field7) — datetime
- email (Field10) — varchar(20)
- phone_num (Field11) — varchar(20)