Mission

Tables (13)

FavoriteFood (Untitled3)

  • ff_id (Key) — LONG — Primary key — NOT NULL
  • user_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL
  • category_id (Key3) — INTEGER — Foreign key → FoodCategory.category_id — NOT NULL

FoodCategory (Untitled2)

  • category_id (Key) — INTEGER — Primary key — NOT NULL
  • category_name (Field) — VARCHAR

Inquery (Untitled9)

  • inquery_id (Key2) — LONG — Primary key — NOT NULL
  • it_pk (Key3) — INTEGER — Foreign key → InqueryType.it_pk — NOT NULL
  • user_id (Key) — LONG — Foreign key → User.user_id — NOT NULL
  • content (Field) — TEXT
  • imgs (Field2) — VARCHAR — NoSQL의 PK
  • answer_status (Field6) — ENUM — WAITING, ANSWERED, REJECTED
  • created_at (Field3) — TIMESTAMP
  • updated_at (Field4) — TIMESTAMP
  • status (Field5) — ENUM — ACTIVE, INACTIVE

InqueryAnswer (Untitled11)

  • ia_pk (Key) — LONG — Primary key — NOT NULL
  • inquery_id (Key2) — LONG — Foreign key → Inquery.inquery_id — NOT NULL
  • content (Field) — TEXT
  • created_at (Field2) — TIMESTAMP
  • updated_at (Field3) — TIMESTAMP
  • status (Field4) — ENUM — ACTIVE, INAVTIVE

InqueryType (Untitled10)

  • it_pk (Key) — INTEGER — Primary key — NOT NULL
  • type (Field) — VARCHAR

Mission (CopyOfCopyOfUntitled)

  • mission_id (Key) — LONG — Primary key — NOT NULL
  • restaurant_id (Key2) — LONG — Foreign key → Restaurant.restaurant_id — NOT NULL
  • condition (Field) — VARCHAR
  • reward (Field2) — VARCHAR
  • dead_line (Field6) — TIMESTAMP
  • created_at (Field3) — TIMESTAMP
  • updated_at (Field4) — TIMESTAMP
  • status (Field5) — ENUM — ACTIVE, INACTIVE

MyMission (Untitled5)

  • mm_id (Key) — LONG — Primary key — NOT NULL
  • mission_id (Key3) — LONG — Foreign key → Mission.mission_id — NOT NULL
  • restaurant_id (Key22) — LONG — Foreign key → Mission.restaurant_id — NOT NULL
  • user_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL
  • mission_status (Field6) — ENUM — WAITING, ACCEPT, DENY, SUCCESS, FAIL
  • code (Field4) — VARCHAR
  • reward (Field5) — INTEGER
  • used_at_goal (Field7) — BOOLEAN — Nullable, True / False
  • created_at (Field) — TIMESTAMP
  • updated_at (Field2) — TIMESTAMP
  • status (Field3) — ENUM — ACTIVE, INACTIVE

PointRecord (Untitled8)

  • point_pk (Key) — LONG — Primary key — NOT NULL
  • user_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL
  • type (Field) — ENUM — ACCUMULATE, DISPERSE
  • reason (Field3) — ENUM — MISSION, CHALLENGE, WITHDRAWAL
  • amount (Field2) — INTEGER
  • mm_id (Key3) — LONG — Foreign key → MyMission.mm_id — NOT NULL — Nullable

Restaurant (CopyOfUntitled)

  • restaurant_id (Key) — LONG — Primary key — NOT NULL
  • name (Field) — VARCHAR
  • national (Field2) — VARCHAR
  • city (Field3) — VARCHAR
  • dong (Field4) — VARCHAR
  • created_at (Field5) — TIMESTAMP
  • updated_at (Field6) — TIMESTAMP
  • status (Field7) — ENUM — ACTIVE, INACTIVE
  • imgs (Field8) — VARCHAR — NoSQL의 PK

RestaurantType (Untitled4)

  • rt_id (Key) — LONG — Primary key — NOT NULL
  • restaurant_id (Key2) — LONG — Foreign key → Restaurant.restaurant_id — NOT NULL
  • category_id (Key3) — INTEGER — Foreign key → FoodCategory.category_id — NOT NULL

Review (Untitled6)

  • review_id (Key) — LONG — Primary key — NOT NULL
  • user_id (Key2) — LONG — Foreign key → User.user_id — NOT NULL
  • restaurant_id (Key3) — LONG — Foreign key → Restaurant.restaurant_id — NOT NULL
  • score (Field4) — INTEGER
  • imgs (Field5) — VARCHAR — NoSQL의 PK
  • content (Field6) — TEXT
  • created_at (Field) — TIMESTAMP
  • updated_at (Field2) — TIMESTAMP
  • status (Field3) — ENUM — ACTIVE, INACTIVE

ReviewAnswer (Untitled7)

  • ra_id (Key) — LONG — Primary key — NOT NULL
  • review_id (Key2) — LONG — Foreign key → Review.review_id — NOT NULL
  • restaurant_id (Key3) — LONG — Foreign key → Review.restaurant_id — NOT NULL
  • content (Field) — TEXT
  • created_at (Field2) — TIMESTAMP
  • updated_at (Field3) — TIMESTAMP
  • status (Field4) — ENUM — ACTIVE, INATIVE

User (Untitled)

  • user_id (Key) — LONG — Primary key — NOT NULL
  • point (Field6) — LONG
  • name (Field) — VARCHAR
  • gender (Field2) — ENUM — FEMALE, MALE, OTHER
  • birth (Field3) — TIMESTAMP
  • address (Field4) — VARCHAR
  • email (Field5) — VARCHAR
  • phone (Field7) — VARCHAR
  • created_at (Field8) — TIMESTAMP
  • updated_at (Field9) — TIMESTAMP
  • status (Field10) — ENUM — ACTIVE, INACTIVE