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