4th workbook
Tables (19)
alarm (Untitled11)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- type (Field) — enum('NEW_EVENT', 'REVIEW_REPLY', 'ASK_REPLY')
- content (Field2) — varchar(100)
- isView (Field3) — boolean
- createdDate (Field4) — datetime(6)
- modifiedDate (Field5) — datetime(6)
alarm_setting (Untitled12)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- receiveNewEvent (Field) — boolean
- receiveReviewReply (Field2) — boolean
- receiveAskReply (Field3) — boolean
- createdDate (Field4) — datetime(6)
- modifiedDate (Field5) — datetime(6)
ask (Untitled13)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- title (Field) — varchar(100)
- content (Field2) — varchar(500)
- type (Field3) — enum('?')
- createdDate (Field4) — datetime(6)
- modifiedDate (Field5) — datetime(6)
ask_image (Untitled14)
- askIdx (Key) — integer — Foreign key → ask.idx — NOT NULL
- src (Field) — varchar(200)
- createdDate (Field2) — datetime(6)
ask_reply (Untitled15)
- idx (Key) — integer — Primary key — NOT NULL
- askIdx (Key2) — integer — Foreign key → ask.idx — NOT NULL
- content (Field) — varchar(500)
- createdDate (Field2) — datetime(6)
- modifiedDate (Field3) — datetime(6)
food_menu (Untitled8)
- idx (Key) — integer — Primary key — NOT NULL
- foodStoreIdx (Key2) — integer — Foreign key → food_store.idx — NOT NULL
- name (Field) — varchar(50)
- price (Field2) — integer
- status (Field5) — enum('ACTIVATED', 'DEACTIVATED', 'DELETED')
- createdDate (Field3) — datetime(6)
- modifiedDate (Field4) — datetime(6)
food_store (Untitled6)
- idx (Key) — integer — Primary key — NOT NULL
- name (Field) — varchar(50)
- status (Field5) — enum('ACTIVATED', 'DEACTIVATED', 'DELETED')
- latitude (Field6) — double
- longitude (Field7) — double
- createdDate (Field3) — datetime(6)
- modifiedDate (Field4) — datetime(6)
food_store_type (Untitled7)
- foodStoreIdx (Key) — integer — Foreign key → food_store.idx — NOT NULL
- foodTypeIdx (not_autoincrement) — integer — Foreign key → food_type.idx — NOT NULL
food_type (Untitled3)
- idx (not_autoincrement) — integer — Primary key — NOT NULL
- name (Field) — varchar(30)
mission (Untitled5)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- foodStoreIdx (Key3) — integer — Foreign key → food_store.idx — NOT NULL
- regionIdx (Key4) — integer — Foreign key → region.idx — NOT NULL
- title (Field) — varchar(50)
- content (Field2) — varchar(200)
- point (Field3) — integer
- status (Field4) — enum('SUCCESS', 'ONGOING', 'AWAITING')
- targetPrice (Field5) — integer
- createdDate (Field6) — datetime(6)
- modifiedDate (Field7) — datetime(6)
mission_certification_code (미션 인증 코드)
- missionIdx (Key) — integer — Foreign key → mission.idx — NOT NULL
- foodStoreIdx (Key2) — integer — Foreign key → food_store.idx — NOT NULL
- code (Field) — varchar(9)
- status (Field4) — enum('ACTIVATED', 'EXPIRED', 'USED')
- expiredDate (Field5) — datetime(6)
- createdDate (Field2) — datetime(6)
- modifiedDate (Field3) — datetime(6)
mission_review (Untitled9)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- foodStoreIdx (Key3) — integer — Foreign key → food_store.idx — NOT NULL
- missionIdx (Key4) — integer — Foreign key → mission.idx — NOT NULL
- content (Field) — varchar(500)
- status (Field2) — enum('ACTIVATED', 'DELETED')
- score (Field3) — double
- createdDate (Field4) — datetime(6)
- modifiedDate (Field5) — datetime(6)
mission_review_image (Untitled10)
- missionReviewIdx (Key) — integer — Foreign key → mission_review.idx — NOT NULL
- src (Field) — varchar(200)
- createdDate (Field2) — datetime(6)
mission_review_reply (Untitled16)
- idx (Key) — integer — Primary key — NOT NULL
- missionReviewIdx (Key2) — integer — Foreign key → mission_review.idx — NOT NULL
- foodStoreIdx (Key3) — integer — Foreign key → food_store.idx — NOT NULL
- content (Field) — varchar(500)
- createdDate (Field2) — datetime(6)
- modifiedDate (Field3) — datetime(6)
region (Untitled18)
- idx (Key) — integer — Primary key — NOT NULL
- name (Field) — varchar(10)
user (Untitled)
- idx (Key) — integer — Primary key — NOT NULL
- email (Field8) — varchar(100)
- name (Field) — varchar(30)
- phone (Field10) — varchar(20)
- gender (Field2) — enum('MALE', 'FEMALE', 'NOTHING')
- birth (Field3) — datetime
- address (Field4) — varchar(200)
- detailAddress (Field5) — varchar(300)
- status (Field9) — enum('ACTIVATED', 'DEACTIVATED', 'DELETED')
- point (Field11) — integer
- createdDate (Field6) — datetime(6)
- modifiedDate (Field7) — datetime(6)
user_authentication (Untitled2)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- secret (using sha256) — varchar(64)
- status (Field2) — enum('ACTIVATED', 'DEACTIVATED', 'DELETED')
- createdDate (Field) — datetime(6)
- modifiedDate (Field3) — datetime(6)
user_like_food_type (Untitled4)
- userIdx (Key) — integer — Foreign key → user.idx — NOT NULL
- foodTypeIdx (not_autoincrement) — integer — Foreign key → food_type.idx — NOT NULL
- createdDate (Field) — datetime(6)
- modifiedDate (Field2) — datetime(6)
user_token (Untitled17)
- idx (Key) — integer — Primary key — NOT NULL
- userIdx (Key2) — integer — Foreign key → user.idx — NOT NULL
- token (Field) — varchar(50)
- expiredDate (Field2) — datetime(6)
- status (Field3) — enum('ACTIVATED', 'EXPIRED', 'MULTI_SESSION_LOGINED')
- createdDate (Field4) — datetime(6)
- modifiedDate (Field5) — datetime(6)