umc

Tables (11)

Copy Of Copy Of user (social_login)

  • Key (social_login_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Field2 (social_code) — INT
  • Field4 (access_token) — VARCHAR(256)

Copy Of user (user_authentication)

  • Key (auth_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Field2 (birthday) — VARCHAR(20)
  • Field3 (gender) — INT
  • Field4 (address) — VARCHAR(20)
  • Field5 (auth_date) — VARCHAR(20)

Untitled (user_password)

  • Key (password_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Field (salt) — VARCHAR(20)
  • Field (password) — VARCHAR(20)

Untitled (user_profile)

  • Key (profile_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Field (nickname) — VARCHAR(20)
  • Field2 (phone_num) — VARCHAR(20)

Untitled (favorite)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (food_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL

Untitled (mission)

  • Key (mission_id) — BIGINT — Primary key — NOT NULL
  • Field (point) — BIGINT
  • Field2 (description) — TEXT

Untitled (mission_status)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → user.Key — NOT NULL
  • Key (mission_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (status) — VARCHAR(20)

Untitled (restaurant)

  • Key (rest_id) — BIGINT — Primary key — NOT NULL
  • Key (food_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(30)
  • Field (address) — VARCHAR(30)
  • Field (grade) — INT

Untitled (food)

  • Key (food_id) — BIGINT — Primary key — NOT NULL
  • Field (food_name) — VARCHAR(20)

Untitled (review)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Key (rest_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (food_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (image_url) — VARCHAR(100)
  • Field (content) — TEXT
  • Field (grade) — INT

user

  • Key (user_id) — BIGINT — Primary key — NOT NULL
  • Field (user_name) — VARCHAR(20)
  • Field2 (login_type) — VARCHAR(20)
  • Field3 (created_at) — DATETIME(6)
  • Field4 (updated_at) — DATETIME(6)
  • Field5 (status) — VARCHAR(15)