biz

Tables (7)

od_detail (Untitled7)

  • Key (od_seq) — Primary key — NOT NULL
  • Key (od_id) — Foreign key → od_master.Key — NOT NULL
  • Key (goods_no) — Foreign key → pr_master.Key — NOT NULL
  • Field
  • Field2

od_master (Untitled6)

  • Key (od_id) — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4

pr_category (Untitled2)

  • Key (category_id) — Primary key — NOT NULL
  • Field (name)
  • Field
  • Field2
  • Field3

pr_master (Untitled)

  • Key (goods_no) — Primary key — NOT NULL
  • Key (category_id) — Foreign key → pr_category.Key — NOT NULL
  • Field
  • Field2
  • Field3

pr_price (Untitled3)

  • Key (goods_no) — Foreign key → pr_master.Key — NOT NULL
  • Field
  • Field2
  • Field3

pr_stock (Untitled4)

  • Key (goods_no) — Foreign key → pr_master.Key — NOT NULL

pr_stock_his (Untitled5)

  • Key (his_idx) — Primary key — NOT NULL
  • Key (goods_no) — Foreign key → pr_stock.Key — NOT NULL