Gong exam V1

Tables (3)

ROLE (Untitled)

  • ROLE_ID (Key) — INT — Primary key — NOT NULL
  • ROLE_NM (Field) — VARCHAR

SUBJECT

  • SUB_ID (Key) — INT — Primary key — NOT NULL
  • SUB_NM (Field) — VARCHAR

USER (Untitled2)

  • USER_UID (Key) — VARCHAR — Primary key — NOT NULL
  • USER_EMAIL (Field) — VARCHAR
  • USER_DISPLAY_NM (Field2) — VARCHAR
  • USER_PHOTO_URL (Field3) — VARCHAR
  • USER_CREATE_DT (Field5) — DATETIME
  • USRE_ROLE_ID (Key2) — INT — Foreign key → ROLE.ROLE_ID — NOT NULL