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