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)