umc
Tables (10)
agreement_term (Untitled10)
- id — BIGINT — Primary key — NOT NULL
- user_agreement_term_id — BIGINT — Foreign key → user_agreement_term.id — NOT NULL
- user_id — BIGINT — Foreign key → user_agreement_term.user_id — NOT NULL
- name — VARCHAR
- info — TEXT
fav_food (Untitled3)
- id — INT — Primary key — NOT NULL
- user_fav_food_id — BIGINT — Foreign key → user_fav_food.id — NOT NULL
- food_name — VARCHAR
mission (Untitled4)
- id — BIGINT — Primary key — NOT NULL
- mission_name — VARCHAR
- mission_point — INT
review (Untitled7)
- id — BIGINT — Primary key — NOT NULL
- user_id (user_Id) — BIGINT — Foreign key → user.id — NOT NULL
- store_Id (store_id) — BIGINT — Foreign key → store.id — NOT NULL
- content — VARCHAR
- rate — TINYINT
review_image (Untitled8)
- id — BIGINT — Primary key — NOT NULL
- review_id — BIGINT — Foreign key → review.id — NOT NULL
- id (id2) — BIGINT — Foreign key → review.user_id — NOT NULL
- id (id22) — BIGINT — Foreign key → review.store_Id — NOT NULL
- img_uri — TEXT
store (Untitled6)
- id — BIGINT — Primary key — NOT NULL
- store_name — VARCHAR
- address1 — VARCHAR
- address2 — VARCHAR
- address3 — VARCHAR
- open_time — VARCHAR
- end_time — VARCHAR
- category — TINYINT
user (Untitled)
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR
- gender — VARCHAR
- birtch — VARCHAR
- address1 — VARCHAR
- address2 — VARCHAR
- socialType — TINYINT
- pont (point) — INT
- account_status — TINYINT
user_agreement_term (Untitled9)
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- agreement_id (agreement_Id) — BIGINT
user_fav_food (Untitled2)
- id — BIGINT — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- userId — BIGINT
- foodId — BIGINT
user_mission (Untitled5)
- id — BIGINT — Primary key — NOT NULL
- mission_Id (mission_id) — BIGIN — Foreign key → mission.id — NOT NULL
- user_id — BIGINT — Foreign key → user.id — NOT NULL
- success_status — TINYINT
- due_date — VARCHAR