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