project_copy

Tables (4)

USER (등록자)

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

auth (권한)

  • authid (Field) — int — Primary key

company (회사.)

  • companyno (Key) — int — Primary key — NOT NULL
  • id (Key2) — VARCHAR — Foreign key → USER.id — NOT NULL
  • companyid (Field) — int
  • companyname (Field2) — VARCHAR

device (기기 정보)

  • deviceid (Key) — int — Primary key — NOT NULL
  • id (Key2) — VARCHAR — Foreign key → USER.id — NOT NULL
  • cre_date (Field) — DATETIME
  • devicename (Field3) — VARCHAR