데이터 설계

테이블 (3)

Untitled (User Info Table)

  • Key — Number — 기본 키 — NOT NULL
  • Field (User_Address) — Character
  • Field (User_PhoneNumber) — Number
  • Field2 (User_age) — Number
  • Field3 (User_ID Card) — Number
  • Field4 (User_Charge) — Character

Untitled (Adminstrator)

  • Key (Admonistractor_Name) — Charactor — 기본 키 — NOT NULL
  • Field2 (Adminstrator_Address) — Character
  • Field3 (Adminstrator_PhoneNumber) — Number
  • Field (Adminstrator_age) — Number
  • Field (Adminstrator_IDCard) — Number
  • Field (Adminstrator_Grade) — Charactor

Untitled2 (Network Info Tabel)

  • Key (NetWork) — Character — 기본 키 — NOT NULL
  • Field (DeviceNumber) — Charactor
  • Field2 (DeviceType) — Charactor
  • Field3 (DeviceName) — Charactor
  • Field4 (Located) — Charactor
  • Field5 (InstallTime) — Number
  • Field6 (InstallManager) — Charactor
  • Field7 (InstallPhoneNumber) — Number
  • Field8 (Opreator) — Charactor
  • Field9 (OperatorPhoneNumber) — Number
  • Field10 (ServiceProcessName) — Charactor
  • Field (ServiceDeveloper) — Charactor
  • Field (Develop Day) — Number
  • Field (Install Dau) — Number
  • Field (ServiceDeveloperPhoneNumber) — Number