floraum-catalog

Tables (7)

catalogs (상품)

  • catalogs_idx (Key) — Primary key — NOT NULL
  • shops_idx (Key2) — Foreign key → shops.shops_idx — NOT NULL
  • products_idx (Key3) — Foreign key → products.products_idx — NOT NULL
  • orders_idx (Key22) — Foreign key → shops.orders_idx — NOT NULL
  • users_idx (Key222) — Foreign key → shops.users_idx — NOT NULL
  • amount (Field) — Integer
  • state (Field2) — Enum
  • price (Field3) — Integer

orders (주문)

  • orders_idx (Key) — Primary key — NOT NULL
  • users_idx (Key2) — Foreign key → users.users_idx — NOT NULL
  • state (Field)

orders_payments (주문내역)

  • Key — Primary key — NOT NULL
  • orders_idx (Key2) — Foreign key → payments.payments_idx — NOT NULL
  • orders_idx (Key3) — Foreign key → orders.orders_idx — NOT NULL
  • catalogs_idx (Key4) — Foreign key → catalogs.catalogs_idx — NOT NULL
  • shops_idx (Key22) — Foreign key → catalogs.shops_idx — NOT NULL
  • products_idx (Key32) — Foreign key → catalogs.products_idx — NOT NULL
  • users_idx (Key5) — Foreign key → users.users_idx — NOT NULL
  • users_idx (Key23) — Foreign key → orders.users_idx — NOT NULL
  • users_idx (Key24) — Foreign key → payments.users_idx — NOT NULL
  • orders_idx (Key222) — Foreign key → catalogs.orders_idx — NOT NULL
  • users_idx (Key2222) — Foreign key → catalogs.users_idx — NOT NULL

payments (결제 내역)

  • payments_idx (Key) — Primary key — NOT NULL
  • users_idx (Key2) — Foreign key → users.users_idx — NOT NULL
  • price (Field)

products (제품)

  • products_idx (Key) — Primary key — NOT NULL
  • name (Field) — String

shops (매장)

  • shops_idx (Key) — Primary key — NOT NULL
  • orders_idx (Key2) — Foreign key → orders.orders_idx — NOT NULL
  • users_idx (Key22) — Foreign key → orders.users_idx — NOT NULL
  • name (Field)
  • location_x (Field2)
  • location_y (Field3)
  • address (Field4)

users (유저)

  • users_idx (Key) — Primary key — NOT NULL
  • name (Field)