LEARN_Users_Auths
Tables (3)
AUTHS
- PK_AUTHS — VARCHAR(50) — Primary key — NOT NULL
- PK_USERS (FK_USERS) — VARCHAR(50) — Foreign key → USERS.PK_USERS — NOT NULL — 대표값
- PK_AUTH_NAMES (FK_AUTH_NAMES) — VARCHAR(50) — Foreign key → AUTH_NAMES.PK_AUTH_NAMES — NOT NULL — 접근권한 대표값
- CREATE_DATE — DATE
AUTH_NAMES
- PK_AUTH_NAMES — VARCHAR(50) — Primary key — NOT NULL — 접근권한 대표값
- AUTH_NAME — VARCHAR(200) — NOT NULL — 접근권한명
USERS
- PK_USERS — VARCHAR(50) — Primary key — NOT NULL — 대표값
- NAME — VARCHAR(200) — NOT NULL — 이름
- PASSWORD — VARCHAR(200) — NOT NULL — 암호화
- EMAIL — VARCHAR(200) — NOT NULL — 이메일
- JOB — VARCHAR(200) — 직책