MallCRM
Tables (6)
Orders (Untitled2)
- order_pk — serial — Primary key — NOT NULL
- order_id (注文番号) — varchar(300)
- order_date (注文日) — date
- order_time (注文時間) — varchar
- Field (注文確認日時)
- Field (発送指示日時)
- payment_method (支払方法名)
Prices (Untitled3)
- price_id (Key) — Primary key — NOT NULL
- price_per (単価) — int
- Field
Products (Untitled)
- product_id (商品ID) — int — Primary key — NOT NULL
- product_name (商品名) — text
- product_no (商品番号) — int
- prod_mno (商品管理番号) — int
Sites (サイト)
- site_id — serial — Primary key — NOT NULL
- site_name
Stores (店舗)
- sotre_id (store_id) — serial — Primary key — NOT NULL
- store_name (店舗名)
Users (Untitled4)
- user_id — uuid — Primary key — NOT NULL
- user_name — text
- user_name_kana — text
- phone — text
- email — text
- address — text