UMC_4th
Tables (9)
Category
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- category — VARCHAR(225)
- status — VARCHAR(225)
- created_at — VARCHAR(225)
- updated_at — VARCHAR(225)
MissionInfo (Missions)
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- region_id — INT — NOT NULL
- description — TEXT
- points_awarded — INT — NOT NULL
- is_recurring — BOOLEAN — NOT NULL
StoreCategory
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- category_id — BIGINT — Foreign key → Category.id — NOT NULL — Auto Increament
- store_id — INT — Foreign key → Stores.id
StoreImage
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- store_id — BIGINT — Foreign key → Stores.id — NOT NULL
- Image_url — TEXT — NOT NULL
StoreReview
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- store_id — BIGINT — Foreign key → Stores.id — NOT NULL — Auto Increament
- user_id — BIGINT — Foreign key → Users.id — NOT NULL — Auto Increament
Stores
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- name — VARCHAR(255) — NOT NULL
- description — TEXT
- address — VARCHAR(255) — NOT NULL
- score — DOUBLE
- open_time (open_timd) — TIME
- close_time — TIME
UserCategory
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- user_id — BIGINT — Foreign key → Users.id — NOT NULL
- category_id — BIGINT — Foreign key → Category.id — NOT NULL
UserMission
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- user_id — INT — Foreign key → Users.id — NOT NULL
- mission_id — BIGINT — Foreign key → MissionInfo.id — NOT NULL
- is_completed — BOOLEAN
- is_reviewd — BOOLEAN
Users
- id — BIGINT — Primary key — NOT NULL — Auto Increament
- username — VARCHAR(255) — NOT NULL — 유저 이름
- email — VARCHAR(255) — NOT NULL — 유저 이메일
- password_hash — VARCHAR(255) — NOT NULL — 유저 패스워드(해쉬값)
- points — INT — 유저 포인트
- status — VARCHAR(225) — 유저 상태(정상, 휴먼, 탈퇴)
- created_at — VARCHAR(225)
- updated_at — VARCHAR(225)