umc1

Tables (12)

Untitled (member)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (provider_id) — VARCHAR(64)
  • Field (provider_type) — VARCHAR(64)
  • Field (agree_tos) — TIMESTAMP
  • Field (agree_privacy) — TIMESTAMP
  • Field (agree_gps) — TIMESTAMP
  • Field (agree_marketing) — TIMESTAMP
  • Field (name) — VARCHAR(16)
  • Field (sex) — ENUM("male","female","none")
  • Field (birthday) — DATE
  • Field (address1) — VARCHAR(256)
  • Field (address2) — VARCHAR(256)
  • Field (registered_at) — TIMESTAMP
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP
  • Field (deleted_at) — TIMESTAMP
  • Field (last_login) — TIMESTAMP
  • Field (nickname) — VARCHAR(64)
  • Field (email) — VARCHAR(256)
  • Field (phone_number) — VARCHAR(32)
  • Field (is_verified_phone_number) — bool
  • Field (notification_new_event) — bool
  • Field (notification_review_reply) — bool
  • Field (notification_ask_reply) — bool
  • Field (current_point) — BIGINT
  • Field

Untitled (food_type)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name_for_user) — VARCHAR(64)
  • Field (name_for_store) — VARCHAR(64)

Untitled (member_prefer_food_type)

  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (food_type_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (store)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(256)
  • Field (address1) — VARCHAR(256)
  • Field2 (address2) — VARCHAR(256)
  • Field (operating_table) — TEXT
  • Key (food_type_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (review)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (score) — double
  • Field (content) — TEXT
  • Field (reply) — TEXT
  • Field2 (reply_at) — TIMESTAMP
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (author_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (review_image)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (image_url) — VARCHAR(1024)
  • Key (review_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (ask)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (title) — VARCHAR(256)
  • Field (content) — TEXT
  • Field (reply) — TEXT
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP
  • Field (type) — VARCHAR(16)
  • Key (author_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (ask_image)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (image_url) — VARCHAR(1024)
  • Key (ask_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (mission)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (point) — BIGINT
  • Field (money) — BIGINT
  • Field (due) — TIMESTAMP
  • Field (state) — ENUM("pending", "progress", "success", "fail")
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (notification)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (type) — ENUM("mission", "review")
  • Key (mission_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (store_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (point_transaction)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (point) — BIGINT
  • Field (type) — ENUM("success_mission", "withdrawal")
  • Field (created_at) — TIMESTAMP
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (mission_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Key (withdrawal_request_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (withdrawal_request)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (state) — ENUM("pending", "approved", "refused")
  • Field (abs_point) — BIGINT
  • Key (member_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (created_at) — TIMESTAMP
  • Field (updated_at) — TIMESTAMP