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