UMC-week01
Tables (7)
Alarm (Untitled7)
- id (PK) — Primary key — NOT NULL
- user_id (FK) — Foreign key → User.id — NOT NULL
- 알림내용 (Field)
Mission (Untitled2)
- id (PK) — Primary key — NOT NULL
- shop_id (FK) — Foreign key → Shop.id — NOT NULL
- reward (Field)
- dueDate (Field2)
- 미션내용 (Field3)
MissionDetail (Untitled3)
- id (PK) — Primary key — NOT NULL
- user_id (FK) — Foreign key → User.id — NOT NULL
- shop_id (FK2) — Foreign key → Mission.shop_id — NOT NULL
- mission_id (FK3) — Foreign key → Mission.id — NOT NULL
- status (Field)
- 구분번호 (Field2)
Review (Untitled6)
- id (PK) — Primary key — NOT NULL
- user_id (FK) — Foreign key → User.id — NOT NULL
- shop_id (FK2) — Foreign key → Shop.id — NOT NULL
- 리뷰내용 (Field)
- 별점 (Field2)
Shop (Untitled4)
- id (PK) — Primary key — NOT NULL
- category (Field)
- address (Field2)
User (Untitled)
- id (PK) — Primary key — NOT NULL
- username (Field)
- gender (Field2)
- birthday (Field3)
- address (Field4)
- point (Field5)
- agreement (Field6)
UserFood (Untitled5)
- id (PK) — Primary key — NOT NULL
- user_id (FK) — Foreign key → User.id — NOT NULL
- preferFood (Field)