ens_database
Tables (5)
biz
- id — INT — Primary key — NOT NULL
- Field (customer_garantee) — DATE
- Field (service_date) — DATE
- Field (note) — TEXT
employee
- Key (id) — INT — Primary key — NOT NULL
- Field (name) — VARCHAR
- Field (userid) — VARCHAR
- Field (password) — VARCHAR
- Field (email) — VARCHAR
log
- Key (id) — INT — Primary key — NOT NULL
- Field (datetime) — DATETIME
- Field (note) — VARCHAR
- Key (part_id) — INT — Foreign key → part.Key — NOT NULL
- Key (system_id) — INT — Foreign key → part.Key — NOT NULL
- id (biz_id) — INT — Foreign key → part.id — NOT NULL
part
- Key (id) — INT — Primary key — NOT NULL
- Key (system_id) — INT — Foreign key → system.Key — NOT NULL
- id (biz_id) — INT — Foreign key → system.id — NOT NULL
- Field (sort) — VARCHAR
- Field (name) — VARCHAR
- Field (vendor) — VARCHAR
- Field (serial) — VARCHAR
- Field (part_garantee) — DATE
- Field (buy_cost) — INT
- Field (buy_from) — VARCHAR
- Field (buy_day) — DATE
- Field (buy_come) — DATE
- Field (note) — VARCHAR
system
- Key (id) — INT — Primary key — NOT NULL
- id (biz_id) — INT — Foreign key → biz.id — NOT NULL
- Field (sort) — VARCHAR
- Field2 (name) — VARCHAR
- Field (vendor) — VARCHAR
- Field (serial) — VARCHAR
- Field (status) — VARCHAR
- Field (system_garantee) — DATE
- Field (buy_cost) — INT
- Field (buy_from) — VARCHAR
- Field (buy_day) — DATE
- Field (buy_come) — DATE
- Field (note) — TEXT