newerd

Tables (3)

OS_ACCOUNT

  • id — BINARY(16) — Primary key — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • phone — VARCHAR(20)
  • is_system_admin — BOOLEAN — NOT NULL
  • status — ENUM('ACTIVE', 'SUSPENDED', 'DELETED') — NOT NULL
  • last_login_dt — TIMESTAMP
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP
  • account_id — BINARY(16) — Foreign key → OS_ACCOUNT.id — NOT NULL
  • permission — VARCHAR(100) — NOT NULL
  • granted_by — BINARY(16)
  • granted_dt — TIMESTAMP — NOT NULL
  • username — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255)
  • phone — VARCHAR(20)
  • status — ENUM('ACTIVE', 'SUSPENDED', 'DELETED') — NOT NULL
  • last_login_dt — TIMESTAMP
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP
  • name — VARCHAR(255) — NOT NULL
  • description — VARCHAR(500)
  • status — ENUM('ACTIVE', 'SUSPENDED', 'DELETED') — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP
  • org_id — BINARY(16) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • description — VARCHAR(255)
  • is_admin — BOOLEAN — NOT NULL
  • priority — INT — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • role_id — BINARY(16) — NOT NULL
  • permission — VARCHAR(100) — NOT NULL
  • account_id — BINARY(16) — NOT NULL
  • org_id — BINARY(16) — NOT NULL
  • requested_name — VARCHAR(255) — NOT NULL
  • message — VARCHAR(500)
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED') — NOT NULL
  • processed_by — BINARY(16)
  • reject_reason — VARCHAR(500)
  • created_dt — TIMESTAMP — NOT NULL
  • processed_dt — TIMESTAMP
  • account_id — BINARY(16) — NOT NULL
  • org_id — BINARY(16) — NOT NULL
  • role_id — BINARY(16) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • status — ENUM('ACTIVE', 'SUSPENDED', 'DELETED') — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP
  • profile_id — BINARY(16) — NOT NULL
  • permission — VARCHAR(100) — NOT NULL
  • granted_by — BINARY(16)
  • granted_dt — TIMESTAMP — NOT NULL
  • expires_dt — TIMESTAMP
  • account_id — BINARY(16) — NOT NULL
  • session_token — VARCHAR(500) — NOT NULL
  • ip_address — VARCHAR(45)
  • user_agent — VARCHAR(500)
  • … +108

OS_TEST

  • id — BINARY(16) — Primary key — NOT NULL
  • org_id — BINARY(16) — NOT NULL
  • folder_id — BINARY(16)
  • test_type_id — BINARY(16) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • total_score — INT
  • scheduled_dt — TIMESTAMP
  • status — ENUM('DRAFT', 'ACTIVE', 'CLOSED', 'ARCHIVED') — NOT NULL
  • created_by — BINARY(16) — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP
  • INDEX — `IX_OS_TEST_ORG`
  • INDEX — `IX_OS_TEST_FOLDER`
  • INDEX — `IX_OS_TEST_TYPE`
  • INDEX — `IX_OS_TEST_STATUS`
  • test_id — BINARY(16) — Foreign key → OS_TEST.id — NOT NULL
  • profile_id — BINARY(16)
  • role_id — BINARY(16)
  • permission — ENUM('VIEW', 'EDIT', 'MANAGE') — NOT NULL
  • granted_by — BINARY(16)
  • granted_dt — TIMESTAMP — NOT NULL
  • org_id — BINARY(16)
  • code — VARCHAR(50) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • answer_type — ENUM('INTEGER', 'DECIMAL', 'GRADE', 'BOOLEAN', 'TEXT') — NOT NULL
  • score_schema — JSON — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • min: — 0
  • max: — 100}
  • grades: — "A"
  • F} — -
  • {type: — "integer",
  • 주관식 — (단답)'
  • {type: — "integer",
  • {type: — "integer",
  • {type: — "boolean"}')
  • {type: — "grade",

OS_TEST_QUESTION

  • id — BINARY(16) — Primary key — NOT NULL
  • test_id — BINARY(16) — Foreign key → OS_TEST.id — NOT NULL
  • question_type_id — BINARY(16) — NOT NULL
  • question_number — INT — NOT NULL
  • content — TEXT
  • max_score — DECIMAL(10, 2) — NOT NULL
  • correct_answer — VARCHAR(255)
  • category — VARCHAR(100)
  • difficulty — ENUM('EASY', 'MEDIUM', 'HARD')
  • created_dt — TIMESTAMP — NOT NULL
  • test_id — BINARY(16) — NOT NULL
  • student_id — BINARY(16) — NOT NULL
  • score_data — JSON — NOT NULL
  • total_score — DECIMAL(10, 2)
  • rank — INT
  • memo — TEXT
  • created_by — BINARY(16) — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP
  • INDEX — `IX_OS_TEST_RESULT_STUDENT`
  • standard_score: — 135
  • percentile: — 95.5
  • grade: — 1}
  • wrong_count: — 2} — NOT NULL
  • result_id — BINARY(16) — NOT NULL
  • question_id — BINARY(16) — NOT NULL
  • answer — VARCHAR(500)
  • score — DECIMAL(10, 2)
  • is_correct — BOOLEAN
  • feedback — TEXT
  • created_dt — TIMESTAMP — NOT NULL
  • updated_dt — TIMESTAMP
  • name — VARCHAR(255) — NOT NULL
  • description — TEXT
  • owner_org_id — BINARY(16) — NOT NULL
  • created_by — BINARY(16) — NOT NULL
  • created_dt — TIMESTAMP — NOT NULL
  • group_id — BINARY(16) — NOT NULL
  • org_id — BINARY(16) — NOT NULL
  • permission — ENUM('VIEW', 'CONTRIBUTE', 'MANAGE') — NOT NULL
  • joined_dt — TIMESTAMP — NOT NULL
  • group_id — BINARY(16) — NOT NULL
  • test_id — BINARY(16) — NOT NULL
  • shared_by — BINARY(16) — NOT NULL
  • shared_dt — TIMESTAMP — NOT NULL
  • test_id — BINARY(16) — NOT NULL
  • student_id — BINARY(16) — NOT NULL
  • gv_account_id — BINARY(16) — NOT NULL
  • request_type — ENUM('ADD', 'MODIFY') — NOT NULL
  • requested_score_data — JSON — NOT NULL
  • current_score_data — JSON
  • reason — TEXT
  • status — ENUM('PENDING', 'APPROVED', 'REJECTED') — NOT NULL
  • processed_by — BINARY(16)
  • reject_reason — VARCHAR(500)
  • created_dt — TIMESTAMP — NOT NULL
  • processed_dt — TIMESTAMP
  • INDEX — `IX_OS_SCORE_REQUEST_TEST`
  • INDEX — `IX_OS_SCORE_REQUEST_STUDENT`
  • INDEX — `IX_OS_SCORE_REQUEST_STATUS`
  • … +51