IEUM
Tables (11)
business_registration (Untitled6)
- id (Key) — BIGINT — Primary key — NOT NULL
- store_id (Key2) — BIGINT — Foreign key → stores.id — NOT NULL
- registration_img_url (Field) — VARCHAR(255)
- approve_at (Field2) — DATETIME
- disapprove_at (Field3) — DATETIME
- created_at (Field4) — DATETIME
- updated_at (Field5) — DATETIME
items_reviews (Untitled8)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_order_id (Key2) — BIGINT — Foreign key → users_orders.id — NOT NULL
- rating (Field6) — INT
- img_url (Field) — VARCHAR(255)
- content (Field2) — TEXT
- blind_at (Field5) — DATETIME
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
order_state (Untitled11)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(50)
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
review_reports (Untitled10)
- id (Key) — BIGINT — Primary key — NOT NULL
- item_review_id (Key2) — BIGINT — Foreign key → items_reviews.id — NOT NULL
- reporter_id (Key3) — BIGINT — Foreign key → users_account.id — NOT NULL
- reason (Field4) — TEXT
- created_at (Field) — DATETIME
- processed_at (Field3) — DATETIME
- updated_at (Field2) — DATETIME
store_type (Untitled5)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(20)
- created_at (Field2) — DATETIME
- update_at (Field3) — DATETIME
stores (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_account_id (Key2) — BIGINT — Foreign key → users_account.id — NOT NULL
- uid (Field5) — VARCHAR(255)
- name (Field) — VARCHAR(20)
- logo_img_url (Field8) — VARCHAR(255)
- store_type_id (Key3) — INT — Foreign key → store_type.id — NOT NULL
- open_at (Field6) — TIME
- close_at (Field7) — TIME
- shutdown_at (Field4) — DATETIME
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
stores_items (Untitled7)
- id (Key) — BIGINT — Primary key — NOT NULL
- store_id (Key2) — BIGINT — Foreign key → stores.id — NOT NULL
- uid (Field) — VARCHAR(255)
- item_img_url (Field2) — VARCHAR(255)
- name (Field3) — VARCHAR(150)
- original_price (Field4) — INT
- sale_price (Field9) — INT
- initial_quantity (Field5) — INT
- remaining_quantity (Field11) — INT
- last_order_time (Field8) — DATETIME
- created_at (Field6) — DATETIME
- updated_at (Field7) — DATETIME
user_type (Untitled3)
- id (Key) — INT — Primary key — NOT NULL
- name (Field) — VARCHAR(100)
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME
users (Untitled)
- id (Key) — BIGINT — Primary key — NOT NULL
- name (Field) — VARCHAR(10)
- tel (Field2) — VARCHAR(11)
- email (Field5) — VARCHAR(100)
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
users_account (Untitled2)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → users.id — NOT NULL
- user_type (Key3) — INT — Foreign key → user_type.id — NOT NULL
- uid (Field) — VARCHAR(32)
- nickname (Field5) — VARCHAR(10)
- password (Field2) — VARCHAR(255)
- exit_at (Field6) — DATETIME
- created_at (Field3) — DATETIME
- updated_at (Field4) — DATETIME
users_orders (Untitled9)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_account_id (Key2) — BIGINT — Foreign key → users_account.id — NOT NULL
- store_item_id (Key3) — BIGINT — Foreign key → stores_items.id — NOT NULL
- quantity (Field) — INT
- order_state_id (Key4) — INT — Foreign key → order_state.id — NOT NULL
- created_at (Field2) — DATETIME
- updated_at (Field3) — DATETIME