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