project

Tables (4)

USER (등록자)

  • id (Key) — int — Primary key — NOT NULL
  • authid (Field9) — int — Foreign key → auth.authid
  • companyno (Key2) — int — Foreign key → company.companyno — NOT NULL
  • pw (Field) — VARCHAR
  • name (Field3) — VARCHAR
  • address (Field4) — VARCHAR
  • cre_date (Field5) — DATETIME
  • mod_date (Field6) — DATETIME
  • phone (Field7) — VARCHAR
  • userinfo (Field2) — VARCHAR

auth (권한)

  • authid (Field) — int — Primary key
  • companyno (Field2) — int
  • name (Field3) — VARCHAR
  • userinfo (Field4) — VARCHAR

company (회사.)

  • companyno (Key) — int — Primary key — NOT NULL
  • companyid (Field) — int
  • companyname (Field2) — VARCHAR
  • companyperson (Field3) — VARCHAR
  • createdate (Field4) — DATETIME
  • updatedate (Field5) — DATETIME

device_info (기기 정보)

  • device_id (Key) — int — Primary key — NOT NULL
  • id (Key2) — int — Foreign key → USER.id — NOT NULL
  • companyno (Key22) — int — Foreign key → USER.companyno — NOT NULL
  • createdate (Field) — DATETIME
  • updatedate (Field2) — DATETIME
  • devicename (Field3) — VARCHAR
  • ip (Field4) — VARCHAR
  • license (Field6) — VARCHAR