smart_i_db
테이블 (35)
게시물 (contents)
- id — SERIAL
- type — content_type — NOT NULL
- category — VARCHAR(255)
- title — VARCHAR(255) — NOT NULL
- grade — INTEGER
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- views — INTEGER — NOT NULL
- is_active — BOOLEAN — NOT NULL
- order — INTEGER
- extra_fields — JSONB
- author_id — INTEGER — 외래 키 → 사용자.id
- organization_id — INTEGER
- subject_id — INTEGER
- file_type — content_file_type
게시물 파일 (content_files)
- id — SERIAL
- content_id — INTEGER — 외래 키 → 게시물.id — NOT NULL
- file_id — INTEGER — NOT NULL
결제 (payments)
- id — SERIAL
- user_id — INTEGER — 외래 키 → 사용자.id — NOT NULL
- enrollment_id — INTEGER
- amount — INTEGER — NOT NULL
- method — payment_method — NOT NULL
- paid_at — TIMESTAMP — NOT NULL
- status — payment_status — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
계약사항 (terms)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- type — terms_type — NOT NULL
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- summary — VARCHAR(255)
- importance — terms_importance — NOT NULL
- version — VARCHAR(50) — NOT NULL
- is_active — BOOLEAN — NOT NULL
- language — VARCHAR(10) — NOT NULL
- effective_date — TIMESTAMP — NOT NULL
- expiry_date — TIMESTAMP
- created_by — INTEGER
- updated_by — INTEGER
과목 (subjects)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
과목 사용자 (_subject_to_user)
- b — INTEGER — 기본 키 — NOT NULL
- a — INTEGER — 외래 키 → 과목.id — NOT NULL
단체 (organizations)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- name — VARCHAR(255) — NOT NULL
- type — organization_type — NOT NULL
- business_number — VARCHAR(50)
- phone — VARCHAR(20)
- email — VARCHAR(255)
- website — VARCHAR(255)
- address — VARCHAR(255)
- location_id — INTEGER — 외래 키 → 지역.id
- parent_id — INTEGER
- is_active — BOOLEAN — NOT NULL
답글 (replies)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- content — TEXT — NOT NULL
- inquiry_id — INTEGER — 외래 키 → 문의.id — NOT NULL
- user_id — INTEGER — NOT NULL
모집 (recruitments)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- start_date — TIMESTAMP — NOT NULL
- end_date — TIMESTAMP
- status — recruitment_status — NOT NULL
- type — recruitment_type
- employment_type — employment_type
- is_urgent — BOOLEAN — NOT NULL
- content — TEXT
- organization_id — INTEGER — 외래 키 → 단체.id
모집 과목 (recruitment_subjects)
- id — SERIAL
- recruitment_id — INTEGER — 외래 키 → 모집.id — NOT NULL
- subject_id — INTEGER — NOT NULL
모집 위치 (recruitment_locations)
- id — SERIAL
- recruitment_id — INTEGER — 외래 키 → 모집.id — NOT NULL
- location_id — INTEGER — NOT NULL
모집 파일 (recruitment_files)
- id — SERIAL
- recruitment_id — INTEGER — 외래 키 → 모집.id — NOT NULL
- file_id — INTEGER — NOT NULL
문의 (inquiries)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- content — TEXT — NOT NULL
- status — inquiry_status — NOT NULL
- inquiry_number — INTEGER — NOT NULL
- user_id — INTEGER — 외래 키 → 사용자.id — NOT NULL
- channel_id — INTEGER — NOT NULL
- inquiry_type_id — INTEGER — NOT NULL
문의 유형 (inquiry_types)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- name — VARCHAR(255) — NOT NULL
- is_active — BOOLEAN — NOT NULL
배너 (banners)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- file_id — INTEGER — 외래 키 → 파일.id
- link_url — VARCHAR(255)
- description — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
- display_order — INTEGER — NOT NULL
- start_date — TIMESTAMP — NOT NULL
- end_date — TIMESTAMP
- type — banner_type — NOT NULL
사용자 (users)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- username — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- gender — gender
- email — VARCHAR(255)
- birth_date — DATE
- location_id — INTEGER — 외래 키 → 지역.id
- organization_id — INTEGER
- role — role — NOT NULL
- organization_name — VARCHAR(255)
사용자 계약 동의 (user_terms_agreements)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- user_id — INTEGER — 외래 키 → 사용자.id — NOT NULL
- status — agreement_status — NOT NULL
- agreed_at — TIMESTAMP
- declined_at — TIMESTAMP
- withdrawn_at — TIMESTAMP
- ip_address — VARCHAR(50)
- user_agent — VARCHAR(255)
- terms_version — VARCHAR(50) — NOT NULL
- notes — VARCHAR(255)
- terms_id — INTEGER — NOT NULL
사용자 소속 (user_affiliations)
- id — SERIAL
- user_id — INTEGER — 외래 키 → 사용자.id — NOT NULL
- affiliation_type — affiliation_type — NOT NULL
연수 (trainings)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- type — training_type — NOT NULL
- level — training_level — NOT NULL
- duration_hours — INTEGER
- max_participants — INTEGER
- min_participants — INTEGER
- is_online — BOOLEAN — NOT NULL
- is_offline — BOOLEAN — NOT NULL
- is_guest_allowed — BOOLEAN — NOT NULL
- instructor_name — VARCHAR(255)
- instructor_info — VARCHAR(255)
- prerequisites — VARCHAR(255)
- learning_objectives — VARCHAR(255)
- thumbnail_file_id — INTEGER — 외래 키 → 파일.id
- organization_id — INTEGER
- content — TEXT
- content_type_id — INTEGER
연수 과목 (training_subjects)
- id — SERIAL
- training_id — INTEGER — 외래 키 → 연수.id — NOT NULL
- subject_id — INTEGER — NOT NULL
연수 기수 (training_cohorts)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- cohort_number — INTEGER — NOT NULL
- cohort_name — VARCHAR(255) — NOT NULL
- status — cohort_status — NOT NULL
- max_participants — INTEGER — NOT NULL
- current_participants — INTEGER — NOT NULL
- registration_start_date — TIMESTAMP
- registration_end_date — TIMESTAMP
- training_start_date — TIMESTAMP
- training_end_date — TIMESTAMP
- location — VARCHAR(255)
- online_link — VARCHAR(255)
- additional_info — VARCHAR(255)
- training_id — INTEGER — 외래 키 → 연수.id — NOT NULL
연수 등록 (training_enrollments)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- status — enrollment_status — NOT NULL
- enrolled_at — TIMESTAMP
- completed_at — TIMESTAMP
- progress_percentage — FLOAT — NOT NULL
- final_score — FLOAT
- guest_name — VARCHAR(255)
- guest_email — VARCHAR(255)
- guest_phone — VARCHAR(20)
- feedback — VARCHAR(255)
- rating — INTEGER
- certificate_issued — BOOLEAN — NOT NULL
- user_id — INTEGER — 외래 키 → 사용자.id
- training_id — INTEGER — NOT NULL
- cohort_id — INTEGER
연수 유형 (training_content_types)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- is_active — BOOLEAN — NOT NULL
연수 이수 조건 (training_completion_conditions)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- condition_type — completion_condition_type — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- required_value — FLOAT
- weight_percentage — FLOAT
- is_required — BOOLEAN — NOT NULL
- order_index — INTEGER — NOT NULL
- training_id — INTEGER — 외래 키 → 연수.id — NOT NULL
연수 커리큘럼 (training_curriculums)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- session_number — INTEGER — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — VARCHAR(255)
- duration_minutes — INTEGER
- content_url — VARCHAR(255)
- is_required — BOOLEAN — NOT NULL
- order_index — INTEGER — NOT NULL
- training_id — INTEGER — 외래 키 → 연수.id — NOT NULL
- content_file_id — INTEGER
연수 파일 (training_files)
- id — SERIAL
- training_id — INTEGER — 외래 키 → 연수.id — NOT NULL
- file_id — INTEGER — NOT NULL
- file_type — VARCHAR(50)
- description — VARCHAR(255)
지역 (locations)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- code — VARCHAR(50) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- level — INTEGER — NOT NULL
- parent_id — INTEGER — 외래 키 → 지역.id
- is_active — BOOLEAN — NOT NULL
지원서 (applications)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- name — VARCHAR(255) — NOT NULL
- contact — VARCHAR(255) — NOT NULL
- gender — gender — NOT NULL
- is_immediate — BOOLEAN — NOT NULL
- user_id — INTEGER — 외래 키 → 사용자.id
- recruitment_id — INTEGER
- status — application_status — NOT NULL
- cover_letter — TEXT
지원서 고용 유형 (application_employment_types)
- id — SERIAL
- application_id — INTEGER — 외래 키 → 지원서.id — NOT NULL
- employment_type — employment_type — NOT NULL
지원서 과목 (application_subjects)
- id — SERIAL
- application_id — INTEGER — 외래 키 → 지원서.id — NOT NULL
- subject_id — INTEGER — NOT NULL
지원서 모집 유형 (application_recruitment_types)
- id — SERIAL
- application_id — INTEGER — 외래 키 → 지원서.id — NOT NULL
- recruitment_type — recruitment_type — NOT NULL
지원서 위치 (application_locations)
- id — SERIAL
- application_id — INTEGER — 외래 키 → 지원서.id — NOT NULL
- location_id — INTEGER — NOT NULL
지원서 파일 (application_files)
- id — SERIAL
- application_id — INTEGER — 외래 키 → 지원서.id — NOT NULL
- file_id — INTEGER — NOT NULL
채널 (channels)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- name — VARCHAR(255) — NOT NULL
- is_active — BOOLEAN — NOT NULL
파일 (files)
- id — SERIAL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- original_name — VARCHAR(255) — NOT NULL
- stored_name — VARCHAR(255) — NOT NULL
- mime_type — VARCHAR(100) — NOT NULL
- size — INTEGER — NOT NULL
- url — VARCHAR(255) — NOT NULL
- bucket — VARCHAR(100) — NOT NULL
- is_public — BOOLEAN — NOT NULL
- description — VARCHAR(255)