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)