test

Tables (15)

account

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • account_status — varchar(255) — NOT NULL
  • INACTIVE::character — varying
  • SUSPENDED::character — varying
  • WITHDRAWN::character — varying
  • LOCK::character — varying
  • DORMANT::character — varying)::text))
  • account_type — varchar(255) — NOT NULL
  • ADMIN::character — varying)::text))
  • auth_provider_type — varchar(255) — NOT NULL
  • NAVER::character — varying
  • KAKAO::character — varying
  • APPLE::character — varying
  • LOCAL::character — varying)::text))
  • email — varchar(255) — NOT NULL
  • email_hash — varchar(255) — NOT NULL
  • email_verified — boolean
  • email_verified_at — timestamp(6)
  • failed_login_attempts — integer — NOT NULL
  • identity_ci_hash — varchar(255) — NOT NULL
  • identity_verification_agreed — boolean — NOT NULL
  • identity_verification_agreed_at — timestamp(6)
  • last_login_at — timestamp(6)
  • login_id — varchar(72) — NOT NULL
  • marketing_reception_agreed — boolean
  • marketing_reception_agreed_at — timestamp(6)
  • password — varchar(255)
  • password_changed_at — timestamp(6) — NOT NULL
  • privacy_policy_agreed — boolean — NOT NULL
  • privacy_policy_agreed_at — timestamp(6)
  • social_provider_id — varchar(255)
  • terms_of_service_agreed — boolean — NOT NULL
  • terms_of_service_agreed_at — timestamp(6)

attendance

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • attendance_rate — integer — NOT NULL
  • check_in_time — timestamp(6)
  • check_out_time — timestamp(6)
  • duration_minutes — integer — NOT NULL
  • chapter_id — bigint
  • lecture_id — bigint
  • member_id — bigint

category

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • depth — integer — NOT NULL
  • name — varchar(255) — NOT NULL
  • parent_id — bigint

certificate

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • certificate_url — varchar(255) — NOT NULL
  • issued_at — timestamp(6) — NOT NULL
  • verification_code — uuid — NOT NULL
  • lecture_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL

chapter

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • chapter_date — date
  • end_time — time(6)
  • name — varchar(255)
  • order_no — integer — NOT NULL
  • start_time — time(6)
  • lecture_id — bigint — NOT NULL

department

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • address — varchar(255)
  • code — varchar(50)
  • department_type — varchar(255) — NOT NULL
  • COMPANY::character — varying)::text))
  • description — varchar(500)
  • is_active — boolean — NOT NULL
  • name — varchar(100) — NOT NULL
  • street — varchar(255)
  • zipcode — varchar(255)

enrollment

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • certificate_status — varchar(255) — NOT NULL
  • IMPOSSIBLE::character — varying)::text))
  • enrollment_type — varchar(255) — NOT NULL
  • CAPACITY_WAIT::character — varying
  • CONFIRMED::character — varying
  • REJECTED::character — varying
  • USER_CANCELLED::character — varying
  • SYSTEM_CANCELLED::character — varying)::text))
  • memo — varchar(255)
  • progress_rate — integer — NOT NULL
  • lecture_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL

enrollment_history

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • canceled_at — timestamp(6)
  • enrollment_type — varchar(255) — NOT NULL
  • CAPACITY_WAIT::character — varying
  • CONFIRMED::character — varying
  • REJECTED::character — varying
  • USER_CANCELLED::character — varying
  • SYSTEM_CANCELLED::character — varying)::text))
  • lecture_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL

lecture

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • access_days — integer
  • address — varchar(255)
  • capacity — integer
  • current_enrollment — integer — NOT NULL
  • current_waitlist — integer — NOT NULL
  • description — text
  • difficulty — varchar(255)
  • BASIC::character — varying
  • INTERMEDIATE::character — varying)::text))
  • end_at — timestamp(6)
  • has_certificate — boolean — NOT NULL
  • has_textbook — boolean — NOT NULL
  • is_deleted — boolean — NOT NULL
  • is_unlimited_capacity — boolean — NOT NULL
  • main_image_url — varchar(255)
  • max_waitlist — integer
  • name — varchar(255)
  • notice — text
  • operation_status — varchar(255) — NOT NULL
  • RECRUITING::character — varying
  • FULL::character — varying
  • IN_PROGRESS::character — varying
  • FINISHED::character — varying)::text))
  • discount_amount — numeric(38, 2)
  • discount_rate — numeric(38, 2)
  • original_price — numeric(38, 2) — NOT NULL
  • sale_price — numeric(38, 2)
  • publish_status — varchar(255) — NOT NULL
  • UNPUBLISHED::character — varying)::text))
  • published_at — timestamp(6)
  • recruit_start_at — timestamp(6)
  • schedule_description — varchar(255)
  • start_at — timestamp(6)
  • street — varchar(255)
  • thumbnail_url — varchar(255)
  • type — varchar(255)
  • ONLINE::character — varying
  • STREAMING::character — varying)::text))
  • updater_id — bigint

lecture_category

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • category_id — bigint
  • lecture_id — bigint

lesson_progress

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • completed — boolean — NOT NULL
  • completed_at — timestamp(6)
  • last_position — integer — NOT NULL
  • member_id — bigint — NOT NULL
  • lesson_id — bigint — NOT NULL

member

  • id — bigint — NOT NULL
  • address — varchar(255)
  • birth — timestamp(6)
  • enrollment_banned_until — timestamp(6)
  • experience_year — timestamp(6)
  • gender — varchar(255)
  • FEMALE::character — varying)::text))
  • mentor_verified — boolean — NOT NULL
  • mentor_verified_at — timestamp(6)
  • mobile_type — varchar(255)
  • KT::character — varying
  • LGU::character — varying
  • SKT_MVNO::character — varying
  • KT_MVNO::character — varying
  • LGU_MVNO::character — varying)::text))
  • name — varchar(255) — NOT NULL
  • name_hash — varchar(255) — NOT NULL
  • national_type — varchar(255)
  • FOREIGN::character — varying)::text))
  • phone_number — varchar(255) — NOT NULL
  • phone_number_hash — varchar(255) — NOT NULL
  • street — varchar(255)
  • zip_code — varchar(255)
  • department_id — bigint

session

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • duration_seconds — integer
  • name — varchar(255)
  • order_no — integer — NOT NULL
  • type — varchar(255)
  • NETWORK_TIME::character — varying
  • BREAK_QNA::character — varying
  • LUNCH_TIME::character — varying
  • COMPLETION::character — varying
  • OFFLINE::character — varying
  • ONLINE::character — varying
  • SURVEY::character — varying)::text))
  • url — varchar(255)
  • chapter_id — bigint — NOT NULL
  • mentor_id — bigint

survey_form

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL
  • deleted_at — timestamp(6)
  • updated_at — timestamp(6)
  • entry_id — varchar(255) — NOT NULL
  • form_url — varchar(255) — NOT NULL
  • google_form_id — varchar(255) — NOT NULL
  • chapter_id — bigint — NOT NULL

survey_response

  • id — bigint — NOT NULL
  • chapter_id — bigint
  • member_id — bigint — NOT NULL
  • raw_payload — text
  • submitted_at — timestamp(6) — NOT NULL
  • survey_form_id — bigint — NOT NULL