장비관리
테이블 (5)
CODE
- CODE — CHAR(3)
- CONTENT — VARCHAR(20) — NOT NULL
- USE_TABLE — VARCHAR(20)
- USE_COL — VARCHAR(20)
EQUIPMENT
- UID — CHAR(36)
- CLASS — CHAR(3) — NOT NULL
- SN — VARCHAR(50)
- MODEL — VARCHAR(50)
- SPEC — VARCHAR(128)
- MANU_YEAR — YEAR
- WAR_START — DATE
- WAR_END — DATE
- MANU_COM — VARCHAR(50)
- AMOUNT — INT
- PATH — VARCHAR(50)
- STATE — CHAR(3) — NOT NULL
EQUIPMENT_USER
- PN — INT — 기본 키 — NOT NULL
- UID — CHAR(36) — 기본 키 — NOT NULL
PROJECT
- PJT_UID — CHAR(36)
- PROJECT — VARCHAR(50)
- PJT_START — DATE
- PJT_END — DATE
- PN — INT — NOT NULL
- PJT_STATE — CHAR(3) — NOT NULL
USER
- PN — INT
- EMAIL — VARCHAR(24) — NOT NULL
- NAME — VARCHAR(20) — NOT NULL
- DEPT — CHAR(3)
- CON — VARCHAR(15)
- POS — CHAR(3)
- STATE — CHAR(3) — NOT NULL