UMC
Tables (6)
mission
- mission_idx — BIGINT — Primary key — NOT NULL
- store_idx (sotre_idx) — BIGINT — Foreign key → store.store_idx — NOT NULL
- mission_type (Field) — varchar(15) — NOT NULL
review
- review_idx — BIGINT — Primary key — NOT NULL
- mission_idx (mission_idx2) — BIGINT — Foreign key → user_mission.mission_idx — NOT NULL
- store_idx (sotre_idx) — BIGINT — Foreign key → store.store_idx — NOT NULL
- title — varchar(15) — NOT NULL
- content — text
store
- store_idx (sotre_idx) — BIGINT — Primary key — NOT NULL
udrees (udress)
- user_id (Key) — BIGINT — Foreign key → user.user_id — NOT NULL
- city — varchar(15)
- state — varchar(15) — NOT NULL
user
- user_id (Key) — BIGINT — Primary key — NOT NULL
- user_name — varchar(15) — NOT NULL
- user_pw — varchar(45) — NOT NULL
- gender — varchar(10)
- phone_number — varchar(15) — NOT NULL
user_mission
- user_mission_idx (mission_idx) — BIGINT — Primary key — NOT NULL
- user_id (Key) — BIGINT — Foreign key → user.user_id — NOT NULL
- mission_idx (Key2) — BIGINT — Foreign key → mission.mission_idx — NOT NULL
- store_idx (sotre_idx) — BIGINT — Foreign key → mission.store_idx — NOT NULL