umc_6th_w4
Tables (13)
Copy Of Untitled (ReviewImage)
- Key (id) — bigint — Primary key — NOT NULL
- Key (review_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (img) — bigint
Copy Of Untitled2 (QuestionImage)
- Key (id) — bigint — Primary key — NOT NULL
- Key (question_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (img) — bigint
FoodCategory
- key (id) — bigint — Primary key — NOT NULL
- field (name) — varchar(20)
- field (content) — varchar(50)
MemberFoodCategory
- Key (id) — bigint — Primary key — NOT NULL
- key (food_category_id) — bigint — Foreign key → FoodCategory.key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
Untitled (Store)
- Key (id) — bigint — Primary key — NOT NULL
- key (food_category_id) — bigint — Foreign key → FoodCategory.key — NOT NULL
- Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (name) — varchar(20)
- Field2 (address) — varchar(30)
- Field (rating) — double
Untitled (MemberMission)
- Key (id) — bigint — Primary key — NOT NULL
- Key (mission_id) — bigint — Foreign key → Untitled4.Key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
Untitled (Review)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
- Field (content) — varchar(200)
- Field2 (rating) — bigint
Untitled (Region)
- Key (id) — bigint — Primary key — NOT NULL
- Field (name) — varchar(30)
Untitled (Alarm)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
- Field (content) — varchar(30)
Untitled (Question)
- Key (id) — bigint — Primary key — NOT NULL
- Key (member_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
- Field (title) — bigint
- Field (content) — bigint
Untitled (StoreImage)
- Key (id) — bigint — Primary key — NOT NULL
- Key (store_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (img) — bigint
Untitled3 (Member)
- Key (id) — BIGINT — Primary key — NOT NULL
- Key (region_id) — bigint — Foreign key → Untitled.Key — NOT NULL
- Field (email) — VARCHAR(30)
- Field2 (name) — varchar(20)
- Field3 (nickname) — varchar(20)
- Field3 (gender) — enum — MALE, FEMALE
- Field4 (point_value) — int
- Field5 (birth_day) — date
- Field (address) — varchar(20)
- Field4 (phone_number) — bigint
Untitled4 (Mission)
- Key (id) — bigint — Primary key — NOT NULL
- Field (state) — enum
- Field (content) — varchar(30)
- Field (lower_price) — bigint
- Field (reward) — bigint
- Field (deadline) — datetime
- Field (authcode) — varchar(20)