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) — 직책