umc_mission
Tables (6)
alarm (Untitled6)
- id (Key) — Primary key — NOT NULL
- status (on/off) — boolean
- title (Field) — varchar(50)
- content (Field2) — text
- created_at (Field3) — date
- updated_at (Field4)
- dtype (Field6)
- is_confirmed (Field5)
- id (Key2) — bigint — Foreign key → user.id — NOT NULL
member_mission (Untitled5)
- id (Key) — Primary key — NOT NULL
- Field
- created_date (Field2)
- updated_date (Field3)
- status (Field4)
- mission_id (Key3) — bigint — Foreign key → mission.id — NOT NULL
- user_id (Key2) — bigint — Foreign key → user.id — NOT NULL
mission (Untitled2)
- id (Key) — bigint — Primary key — NOT NULL
- created_date (Field2) — datetime
- updated_date (Field3) — datetime
- price (Field) — int
- point (Field4) — int
- store_id (Key2) — bigint — Foreign key → store.id — NOT NULL
review (Untitled4)
- id (Key) — bigint — Primary key — NOT NULL
- score (Field) — float
- content (Field2) — text
- photo (Field3) — image
- id (Key2) — bigint — Foreign key → user.id — NOT NULL
- id (Key3) — bigint — Foreign key → store.id — NOT NULL
store (Untitled3)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(50)
- price (Field2) — int
- certi_num (Field3) — int
- latitude (Field4) — int
- longitude (Field5) — int
user (Untitled)
- id (Key) — bigint — Primary key — NOT NULL
- name (Field) — varchar(50) — NOT NULL
- gender (Field2) — enum
- birthdat (Field3) — date
- food (Field4) — varchar(50)
- address (Field9) — varchar(60)
- created_date (Field5) — datetime(6)
- updated_date (Field6) — datetime(6)
- status (Field7) — varchar(15)
- inactive_date (Field8) — datetime
- total_point (Field10) — bigint
- phone_num (Field11)