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)