week01
Tables (6)
Food (Untitled4)
- FoodID — int — Primary key — NOT NULL
- 음식명 (FoodName) — varchar(255)
- UserID — int — Foreign key → User_Food.UserID — NOT NULL
Mission (Untitled)
- MissionID — int — Primary key — NOT NULL
- 미션설명 (MissionExplain) — text
- 미션상태 (Status) — enum("진행중","완료)
- 포인트 (RewardPoints) — int
- 지역 (Region) — varchar(100)
- 미션인증번호 (MissionAuthNumber) — varchar(50)
- 미션이름 (MissionName) — varchar(255)
- UserID — int — Foreign key → User.UserID — NOT NULL
MissionPerformance (Untitled5)
- PerformanceID — int — Primary key — NOT NULL
- 수행날짜 (PerformDate) — date
- 리뷰상태 (ReviewStatus) — enum("작성여부", "미작성")
- StoreID — int — Foreign key → Store.StoreID — NOT NULL
- UserID — int — Foreign key → User.UserID — NOT NULL
- MissionID — int — Foreign key → Mission.MissionID — NOT NULL
Store (Untitled6)
- StoreID — int — Primary key — NOT NULL
- 가게이름 (StoreName) — varchar(100)
- 주소 (StoreAddr) — vatchar(255)
- 전화번호 (PhoneNumber) — varchar(15)
- 가게설명 (StoreExplain) — text
User (Untitled2)
- UserID — int — Primary key — NOT NULL
- 이름 (UserName) — varchar(255)
- 성별 (UserSex) — enum("남", "여", "선택안함")
- 생년월일 (UserBirth) — data
- 주소 (UserAddr) — varchar(255)
- 포인트 (UserPoint) — int
- FoodID — int — Foreign key → User_Food.FoodID — NOT NULL
User_Food (Untitled3)
- UserID — int — Primary key — NOT NULL
- FoodID — int — Primary key — NOT NULL