111

Tables (8)

client

  • client_id — bigint — Primary key — NOT NULL
  • name — varchar(30)
  • phone — varchar(15)
  • address — varchar(100)
  • birth — varchar(8)
  • created_at — timestamp
  • updated_at — datetime

client_career

  • career_id — bigint — Primary key — NOT NULL
  • client_id — bigint — Foreign key → client.client_id — NOT NULL
  • start_date — datetime
  • end_date — datetime
  • job — varchar(30)

goods

  • goods_id — bigint — Primary key — NOT NULL
  • name — varchar(50)
  • details — varchar(300)
  • price — int
  • category — varchar(15)
  • created_at — timestamp
  • updated_at — datetime

goods_production

  • goods_production_id — bigint — Primary key — NOT NULL
  • goods_id — bigint — Foreign key → goods.goods_id — NOT NULL
  • manufacturing_number — bigint — Foreign key → manufacturing.manufacturing_number — NOT NULL
  • manufacture_date — datetime
  • validation_date — datetime
  • supply_price — int
  • created_at — timestamp
  • updated_at — datetime

manufacturing

  • manufacturing_number — varchar(30) — Primary key — NOT NULL
  • name — varchar(30)
  • address — varchar(100)
  • zip_code — varchar(5)
  • phone — varchar(15)
  • homepage — varchar(100)
  • email — varchar(100)
  • created_at — timestamp
  • updated_at — datetime

order

  • order_id — bigint — Primary key — NOT NULL
  • client_id — bigint — Foreign key → client.client_id — NOT NULL
  • order_date — datetime
  • total_amout — int
  • created_at — timestamp
  • updated_at — datetime

order_goods

  • order_goods_id — bigint — Primary key — NOT NULL
  • order_id — bigint — Foreign key → order.order_id — NOT NULL
  • goods_id — bigint — Foreign key → goods.goods_id — NOT NULL
  • created_at — timestamp
  • updated_at — datetime

staff

  • staff_number — varchar(30) — Primary key — NOT NULL
  • name — varchar(30)
  • gender — char(1)
  • department — varchar(30)
  • join_date — date
  • manufacturing_number — varchar(30) — Foreign key → manufacturing.manufacturing_number — NOT NULL
  • created_at — timestamp
  • updated_at — datetime