CSR diagram
Tables (3)
Customer_info
- ID — int — Primary key — NOT NULL — 엔지니어 ID
- Customer_name — varchar2(50) — NOT NULL
- Field2
- ACS_Contract_Days — int
- ACS_Contract_Hours — int — ACS 계약시간
Engineer_info
- Engineer_id — int — Primary key — NOT NULL — 엔지니어 ID
- Engineer_name — varchar2(50) — NOT NULL
- dept_id — int — NOT NULL — engineer가 소속된 부서
Login
- Loginid — varchar2(50) — Primary key — NOT NULL
- passwd — varchar2(50)