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