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