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