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