UMCTEST

Tables (10)

Food

  • id — Primary key — NOT NULL
  • category — VARCHAR(50) — NOT NULL

Inquiry

  • Key — Primary key — NOT NULL
  • id — BIGINT
  • title — VARCHAR(100)
  • content — TEXT
  • question_type — ENUM('GENERAL','BUG','ETC') — NOT NULL
  • image_url — VARCHAR(255)
  • user_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • deleted_at — DATETIME
  • id (id2) — Foreign key → User.id — NOT NULL

Mission

  • Key — Primary key — NOT NULL
  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • id (id2) — Foreign key → User.id — NOT NULL

Notification

  • id (Key) — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • title — VARCHAR(100)
  • content — TEXT
  • is_read — BOOLEAN
  • created_at — DATETIME
  • Field
  • id (id2) — Foreign key → User.id — NOT NULL

Review

  • Key — Primary key — NOT NULL
  • id — BIGINT
  • star_point — TINYINT — NOT NULL
  • content — TEXT
  • created_at — DATETIME
  • deleted_at — DATETIME
  • user_id — BIGINT — NOT NULL
  • id (id2) — Foreign key → User.id — NOT NULL

ReviewComment

  • Key — Primary key — NOT NULL
  • id — BIGINT
  • content — TEXT
  • created_at — DATETIME
  • review_id — BIGINT — NOT NULL
  • Key (Key2) — Foreign key → Review.Key — NOT NULL

Store

  • id — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • region — VARCHAR(50)
  • Key — Foreign key → UserVisitedStore.Key — NOT NULL
  • Key (Key2) — Foreign key → Mission.Key — NOT NULL

User

  • id — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • gender — ENUM('MALE','FEMALE','OTHER') — NOT NULL
  • birth_date — DATETIME
  • address — VARCHAR(255)
  • point — BIGINT
  • phone_number — VARCHAR(20)
  • email — VARCHAR(100)
  • is_phone_verified — BOOLEAN
  • is_notification_enabled — BOOLEAN
  • is_deleted — BOOLEAN
  • created_at — DATETIME

UserFavoriteFood

  • id — Primary key — NOT NULL
  • user_id — BIGINT — NOT NULL
  • food_id — BIGINT — NOT NULL
  • id (id2) — Foreign key → User.id — NOT NULL
  • id (id3) — Foreign key → Food.id — NOT NULL

UserVisitedStore

  • Key — Primary key — NOT NULL
  • id — BIGINT
  • user_id — BIGINT — NOT NULL
  • store_id — BIGINT — NOT NULL
  • created_at — DATETIME
  • id (id2) — Foreign key → User.id — NOT NULL