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