UMC-7

Tables (13)

Food Catergories (FoodCategories)

  • id — int — Primary key — NOT NULL
  • userid — int — Foreign key → User.id — NOT NULL
  • categories (카테고리) — varchar(50)

Mission

  • id — int — Primary key — NOT NULL
  • storeid (가게id) — int — Foreign key → Store.id — NOT NULL
  • contents (내용) — varchar(4000)
  • point (포인트) — int
  • duedate (마감일) — date

Notification

  • id — int — Primary key — NOT NULL
  • userid — int — Foreign key → User.id — NOT NULL
  • type — ENUM
  • content — varchar(200)
  • notificationtime — date
  • visited — boolean

Point

  • id — int — Primary key — NOT NULL
  • userid — int — Foreign key → User.id — NOT NULL
  • missionid — int — Foreign key → Mission.id — NOT NULL
  • point — int

Region

  • id — int — Primary key — NOT NULL
  • region (지역) — varchar(200)

Report

  • id — int — Primary key — NOT NULL
  • userid (유저id) — int — Foreign key → User.id — NOT NULL
  • title (제목) — varchar(200)
  • content (내용) — varchar(4000)
  • status (상태) — ENUM

ReportPhotos

  • id — int — Primary key — NOT NULL
  • postid — int — Foreign key → Report.id — NOT NULL
  • content (사진내용) — varchar(200)

Review

  • id — int — Primary key — NOT NULL
  • storeid (가게id) — int — Foreign key → Store.regionid — NOT NULL
  • score (리뷰 별점) — int
  • content (리뷰 내용) — varchar(4000)

Store

  • id — int — Primary key — NOT NULL
  • regionid (지역id) — int — Foreign key → Region.id — NOT NULL
  • name (이름) — varchar(200)
  • type (가게 종류) — varchar(50)

Terms

  • id — int — Primary key — NOT NULL
  • title (제목) — varchar(200)
  • description (내용) — varchar(4000)

User

  • id — int — Primary key — NOT NULL
  • name (이름) — varchar(50)
  • gender (성별) — int
  • birthdate (생년월일) — date
  • address (주소) — varchar(200)
  • likedFood (좋아한 음식)
  • nickname (닉네임) — varchar(200)
  • email (이메일) — varchar(200)
  • phonenum (전화번호) — varchar(200)

User Agreed Terms (UserAgreedTerms)

  • userid — int — Foreign key → User.id — NOT NULL
  • termid — int — Foreign key → Terms.id — NOT NULL
  • agreed (동의여부) — boolean

UserMission

  • id — int — Primary key — NOT NULL
  • missionid (미션id) — int — Foreign key → Mission.id — NOT NULL
  • userid (유저id) — int — Foreign key → User.id — NOT NULL
  • startdate (시작시간) — date
  • status (상태) — ENUM