erd

Tables (5)

equ_user (Untitled3)

  • equ_num (Key) — VARCHAR(32) — Foreign key → equipment.equ_num — NOT NULL
  • id (Key2) — INT(16) — Foreign key → user.id — NOT NULL
  • use_start (Field) — DATE

equipment (Untitled2)

  • equ_num (Key) — VARCHAR(32) — Primary key — NOT NULL
  • equ_code (Field7) — VARCHAR(32)
  • equ_name (Field2) — VARCHAR(32)
  • equ_type (Field) — VARCHAR(32)
  • equ_role (Field4) — VARCHAR(32)
  • equ_supplier (Field5) — VARCHAR(32)
  • equ_date (Field6) — DATE
  • equ_price (Field3) — VARCHAR(32)
  • equ_count (Field9) — int(16)
  • equ_cost (Field10) — VARCHAR(16)
  • equ_memo (Field11) — VARCHAR(32)

lic_equ (Untitled5)

  • equ_num (Key) — VARCHAR(32) — Foreign key → equipment.equ_num — NOT NULL
  • lic_num (Key2) — INT(16) — Foreign key → license.lic_num — NOT NULL
  • lic_modified (Field) — DATE
  • create_at (Field2) — DATE

license (Untitled4)

  • lic_num (Key) — INT(16) — Primary key — NOT NULL
  • lic_name (Field) — VARCHAR(32)
  • lic_type (Field2) — VARCHAR(32)
  • lic_purdate (Field3) — VARCHAR(32)
  • lic_purplace (Field4) — VARCHAR(50)
  • lic_purprice (Field5) — INT(16)
  • lic_account (Field6) — VARCHAR(16)
  • lic_password (Field7) — VARCHAR(16)
  • Field8

user (Untitled)

  • id (Key) — INT(16) — Primary key — NOT NULL
  • password (Field2) — VARCHAR(16)
  • name (Field3) — VARCHAR(16)
  • working (Field) — BOOLEAN
  • startdate (Field4) — DATE