← 스키마 목록

exam_question

9개 컬럼 · 792 kB

행 수

1,280

참조하는 테이블

1

이 테이블 → 다른 테이블

참조받는 테이블

0

다른 테이블 → 이 테이블

사용하는 API

0

아직 쓰이지 않음

컬럼

이름	타입	NULL	기본값
`id`	`integer`	NOT NULL	`nextval('exam_question_id_seq'::regclass)`
`exam_id`	`integer`	NOT NULL	—
`question_number`	`smallint`	NOT NULL	—
`question_text`	`text`	NOT NULL	—
`format`	`character varying(20)`	NOT NULL	`'multiple_choice'::character varying`
`explanation`	`text`	—	—
`sort_order`	`smallint`	NOT NULL	`0`
`created_at`	`timestamp without time zone`	—	`now()`
`choices`	`jsonb`	—	—

관계

참조함 →

exam_id→exam.id

제약 · 인덱스

FOREIGN KEY (exam_id) REFERENCES exam(id) ON DELETE CASCADE
PRIMARY KEY (id)
UNIQUE (exam_id, question_number)

exam_question_exam_id_question_number_key
exam_question_pkey
idx_exam_question_exam

이 테이블을 쓰는 API (0)

아직 이 테이블을 조회하는 엔드포인트가 없습니다.

샘플 데이터 (최근 5행)

id	exam_id	question_number	question_text	format	explanation	sort_order	created_at	choices
2439	122	20	Which of the following should be included in a lesson plan?	multiple_choice	—	20	2026-08-20 06:41:40	[{"key":"a","text":"Objective","correct":false},{"key":"b","text":"Time limit","correct":false},{"key":"c","text":"Steps","correct":false},{"key":"d","text":"All the above","correct":true}]
2438	122	19	Material, books, and picture books used by English teachers in first language English classes are called _______________…	multiple_choice	—	19	2026-08-20 06:41:40	[{"key":"a","text":"Real-World Texts","correct":false},{"key":"b","text":"Authentic Texts","correct":true},{"key":"c","text":"Topic-based Texts","correct":false},{"key":"d","text":"Actual Texts","correct":false}]
2437	122	18	The number and frequency of hours of English taught per week, how English is integrated, and resources available to teac…	multiple_choice	—	18	2026-08-20 06:41:40	[{"key":"a","text":"Learner","correct":false},{"key":"b","text":"Institution/Contextual","correct":true},{"key":"c","text":"Teacher","correct":false},{"key":"d","text":"Parent","correct":false}]
2436	122	17	A document that explains the course content, why the course is taught, completion requirements, and can be used as a con…	multiple_choice	—	17	2026-08-20 06:41:40	[{"key":"a","text":"Syllabus","correct":true},{"key":"b","text":"Course Outline","correct":false},{"key":"c","text":"Contract","correct":false},{"key":"d","text":"Policy","correct":false}]
2435	122	16	__________________ is designed at three levels for learners ages 7-12 years of age: Starter, Movers, Flyers.	multiple_choice	—	16	2026-08-20 06:41:40	[{"key":"a","text":"The Cambridge English: Young Learners tests","correct":true},{"key":"b","text":"Summative Assessment","correct":false},{"key":"c","text":"Common European Framework of Reference (CEFR)","correct":false},{"key":"d","text":"Formative","correct":false}]