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)