UMC6th
Tables (9)
ADDRESS
- id (Field) — BIGINT — Primary key — NOT NULL
- user_id (Field3) — BIGINT — Foreign key → USER.id — NOT NULL
- address (Field2) — VARCHAR(30) — NOT NULL
- address_detail (Field4) — VARCHAR(100) — NOT NULL
LikeFoodCat (Untitled7)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Field) — BIGINT — Foreign key → USER.id — NOT NULL
- restarunt_id (Key2) — BIGINT — Foreign key → RESTARUNT_CATEGORY.id — NOT NULL
MISSION (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Field6) — BIGINT — Foreign key → USER.id — NOT NULL
- restarunt_id (Key2) — BIGINT — Foreign key → RESTARUNT.id — NOT NULL
- region_name (Field5) — VARCHAR(10) — Foreign key → REGION.region_name — NOT NULL
- price (Field) — INT — NOT NULL
- saved_point (Field2) — INT — NOT NULL
- dead_line (Field3) — DATE — NOT NULL
- created_at (Field7) — DATE — NOT NULL
- is_completed (Field4) — BOOLEAN — NOT NULL
REGION (Untitled5)
- region_name (Field) — VARCHAR(10) — Primary key — NOT NULL
- completed_mission_cnt (Field2) — INT — NOT NULL
- is_finish (Field3) — BOOLEAN — NOT NULL
RESTARUNT (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- category_id (Key2) — BIGINT — Foreign key → RESTARUNT_CATEGORY.id — NOT NULL
- name (Field) — VARCHAR(20) — NOT NULL
- rating (Field3) — FLOAT — NOT NULL
- location (Field4) — VARCHAR(40) — NOT NULL
- office_hours (Field2) — TIME — NOT NULL
RESTARUNT_CATEGORY (Untitled6)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(15) — NOT NULL
REVIEW (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Field2) — BIGINT — Foreign key → USER.id — NOT NULL
- restarunt_id (Key2) — BIGINT — Foreign key → RESTARUNT.id — NOT NULL
- review (Field) — TEXT — NOT NULL
- rating (Field3) — FLOAT — NOT NULL
REVIEW_PHOTO (CopyOfUntitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- review_id (Key2) — BIGINT — Foreign key → REVIEW.id — NOT NULL
- review_img_url (Field2) — VARCHAR
USER (Untitled)
- id (Field) — BIGINT — Primary key — NOT NULL
- name (Field2) — VARCHAR(10) — NOT NULL
- nickname (Field5) — VARCHAR(10) — NOT NULL
- gender (Field3) — VARCHAR(10) — NOT NULL
- birth (Field4) — DATE — NOT NULL
- point (Field6) — INT — NOT NULL