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