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