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