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