테스트

테이블 (42)

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 — 계정
  • MENTOR::character — varying
  • 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) — 서비스

account_role

  • id — bigint — NOT NULL — 계정-역할
  • account_id — bigint — NOT NULL — 계정
  • role_id — bigint — NOT NULL — 역할

activity_log

  • id — bigint — NOT NULL — 활동로그
  • account_id — bigint — NOT NULL — 계정
  • action — varchar(255) — NOT NULL — 활동
  • LOGOUT::character — varying
  • PASSWORD_CHANGE::character — varying
  • WRITE::character — varying
  • READ::character — varying
  • UPDATE::character — varying
  • DELETE::character — varying
  • EXCEL_DOWNLOAD::character — varying
  • READ_PRIVATE_INFO::character — varying)::text))
  • activity_at — timestamp(6) — NOT NULL — 생성일
  • activity_detail — varchar(100) — 활동
  • activity_reason — varchar(255) — 사유
  • ip — varchar(255) — NOT NULL — 요청
  • status — varchar(255) — NOT NULL — 활동
  • FAIL::character — varying)::text))
  • type — varchar(255) — NOT NULL — 활동
  • MEMBER::character — varying
  • MENTOR::character — varying
  • ACCOUNT::character — varying
  • ROLE::character — varying
  • ACTIVITY_HISTORY::character — varying
  • MY_PAGE::character — varying
  • LECTURE::character — varying
  • LECTURE_QNA::character — varying)::text))

admin

  • id — bigint — NOT NULL — 계정
  • 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 — 연락처
  • department_id — bigint — 소속
  • updater_id — bigint — 수정자

admin_password_history

  • id — bigint — NOT NULL — 히스토리
  • changed_at — timestamp(6) — NOT NULL — 생성일
  • password — varchar(255) — NOT NULL — 히스토리
  • admin_id — bigint — 관리자

bad_word

  • id — bigint
  • word — varchar(255) — NOT NULL

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
  • SCHEDULED::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 — 회원

job

  • id — bigint — NOT NULL — 직무
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • job_type — varchar(255) — NOT NULL — 직무타입
  • COORDINATOR::character — varying
  • NURSE::character — varying
  • NURSE_ASSISTANT::character — varying
  • SKIN_CARE::character — varying
  • ETC::character — varying)::text))

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
  • 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) — 도로명주소
  • target_condition — varchar(255) — 모집대상
  • thumbnail_url — varchar(255) — 썸네일
  • type — varchar(255) — 강의
  • ONLINE::character — varying
  • STREAMING::character — varying)::text))
  • updater_id — bigint — 최근
  • is_unlimited_capacity — boolean

lecture_bookmark

  • id — bigint — NOT NULL — 강의
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • lecture_id — bigint — NOT NULL
  • member_id — bigint — NOT NULL

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 — 강의

lecture_edit_history

  • id — bigint — NOT NULL — 강의
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • edit_type — varchar(255) — NOT NULL — 수정
  • CURRICULUM::character — varying
  • MAIN_IMAGE::character — varying
  • DESCRIPTION::character — varying
  • NOTICE::character — varying)::text))
  • reason — varchar(255) — NOT NULL — 수정
  • lecture_id — bigint — NOT NULL — 강의
  • updater_id — bigint — NOT NULL — 수정자

lecture_qna

  • id — bigint — NOT NULL — 강의
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • content — text — NOT NULL — 내용
  • delete_reason — varchar(255) — 삭제
  • is_deleted — boolean — NOT NULL — 삭제
  • is_private — boolean — NOT NULL — 공개
  • private_reason — varchar(255) — 비공개
  • status — varchar(255) — NOT NULL — 답변
  • ANSWERED::character — varying)::text))
  • title — varchar(255) — NOT NULL — 제목
  • deleter_id — bigint — 삭제자
  • lecture_id — bigint — NOT NULL — 강의
  • session_id — bigint — 세션
  • member_id — bigint — NOT NULL — 작성자

lecture_qna_comment

  • id — bigint — NOT NULL — 강의
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • approved_at — timestamp(6) — 승인
  • content — text — NOT NULL — 댓글
  • is_deleted — boolean — NOT NULL — 삭제
  • status — varchar(255) — NOT NULL — 게시
  • APPROVED::character — varying)::text))
  • writer_type — varchar(255) — 답변
  • MENTOR::character — varying
  • ADMIN::character — varying)::text))
  • admin_id — bigint — 작성자
  • approver_id — bigint — 승인자
  • lecture_qna_id — bigint — NOT NULL — 강의
  • member_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))
  • nickname — varchar(20) — NOT NULL — 사용자
  • phone_number — varchar(255) — NOT NULL — 연락처
  • phone_number_hash — varchar(255) — NOT NULL — 연락처
  • profile_image_url — varchar(255) — NOT NULL — 사용자
  • street — varchar(255) — 도로명
  • zip_code — varchar(255) — 우편번호
  • department_id — bigint — 소속
  • device_token — varchar(255)
  • push_channel_type — varchar(255)
  • FCM::character — varying)::text))

member_job

  • id — bigint — NOT NULL — 회원-직무
  • name — varchar(255) — 직무명
  • job_id — bigint — 직무
  • member_id — bigint — 회원

member_notification

  • id — bigint — NOT NULL — 알림
  • agreed — boolean — NOT NULL — 알림
  • notification_category — varchar(255) — NOT NULL — 알림
  • LECTURE::character — varying
  • COMMUNITY::character — varying
  • QNA::character — varying)::text))
  • profile_id — bigint — NOT NULL — 회원

member_profile

  • id — bigint — NOT NULL — 프로필
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • introduction — varchar(1000) — 프로필
  • is_default — boolean — NOT NULL — 선택
  • nickname — varchar(20) — NOT NULL — 사용자
  • profile_image_url — varchar(255) — NOT NULL — 사용자
  • profile_type — varchar(255) — NOT NULL — 프로필
  • MENTOR::character — varying)::text))
  • member_id — bigint — 회원

message_send_log

  • id — bigint — NOT NULL — 메시지
  • account_id — bigint — 발송
  • channel_type — varchar(255) — 메시지
  • MOBILE::character — varying
  • EMAIL::character — varying
  • KAKAO::character — varying
  • WEB::character — varying)::text))
  • device_token — varchar(255) — 앱
  • email — varchar(255) — 이메일
  • message_type — varchar(255) — 메시지
  • INFORMATION::character — varying
  • LEGAL::character — varying)::text))
  • phone_number — varchar(255) — 휴대폰
  • reason — varchar(1000) — 발송
  • status — smallint — NOT NULL — 발송
  • template_id — bigint — NOT NULL — 메시지
  • message_channel_type — varchar(255)
  • MOBILE::character — varying
  • EMAIL::character — varying
  • KAKAO::character — varying
  • WEB::character — varying)::text))
  • notification_id — bigint — NOT NULL
  • notification_type — varchar(255)
  • INFORMATION::character — varying
  • LEGAL::character — varying)::text))

message_template

  • id — bigint — NOT NULL — 메세지
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • channel_type — varchar(255)
  • MOBILE::character — varying
  • EMAIL::character — varying
  • KAKAO::character — varying
  • WEB::character — varying)::text))
  • message_type — varchar(255)
  • INFORMATION::character — varying
  • LEGAL::character — varying)::text))
  • notification_id — bigint — NOT NULL — 사용

notification

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • last_fired_at — timestamp(6) — 마지막
  • name — varchar(100) — NOT NULL — 알림
  • notification_type — varchar(255) — NOT NULL — 발송
  • LECTURE_LIKED::character — varying
  • COMMENT_REPLIED::character — varying
  • PAYMENT_COMPLETED::character — varying)::text))
  • scheduled_at — timestamp(6) — 발송
  • status — varchar(255) — NOT NULL
  • IN_PROGRESS::character — varying
  • COMPLETED::character — varying
  • CANCELLED::character — varying)::text))
  • target_type — varchar(255) — NOT NULL — 발송
  • PHONE::character — varying
  • EMAIL::character — varying
  • PARAMETER_MEMBER_ID::character — varying
  • PARAMETER_PHONE::character — varying
  • PARAMETER_EMAIL::character — varying)::text))
  • notification_category — varchar(255) — NOT NULL
  • LECTURE::character — varying
  • COMMUNITY::character — varying
  • QNA::character — varying)::text))
  • notification_tag — varchar(255) — NOT NULL
  • LECTURE_LIKED::character — varying
  • COMMENT_REPLIED::character — varying
  • PAYMENT_COMPLETED::character — varying
  • MENTOR_ASSIGNED::character — varying)::text))

notification_inbox

  • id — bigint — NOT NULL — 사용자
  • account_id — bigint — NOT NULL — 알림을
  • account_type — varchar(255) — NOT NULL — 사용자
  • ADMIN::character — varying)::text))
  • body — varchar(255) — NOT NULL — 알림
  • created_at — timestamp(6) — NOT NULL — 생성
  • is_read — boolean — NOT NULL — 읽음
  • notification_category — varchar(255) — NOT NULL — 알림
  • LECTURE::character — varying
  • COMMUNITY::character — varying
  • QNA::character — varying)::text))
  • notification_tag — varchar(255) — NOT NULL — 알림
  • LECTURE_LIKED::character — varying
  • COMMENT_REPLIED::character — varying
  • PAYMENT_COMPLETED::character — varying
  • MENTOR_ASSIGNED::character — varying)::text))
  • profile_type — varchar(255) — 사용자
  • MENTOR::character — varying)::text))
  • title — varchar(255) — NOT NULL — 알림
  • url — varchar(255) — 이동

notification_template

  • notification_id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • body — varchar(255) — NOT NULL — 알림
  • title — varchar(255) — NOT NULL — 알림
  • url — varchar(255) — 이동

permission

  • id — bigint — NOT NULL — 권한
  • description — varchar(500) — 권한
  • group_type — varchar(50) — NOT NULL — 권한
  • ADMIN::character — varying
  • ROLE::character — varying
  • ACTIVITY_LOG::character — varying
  • LECTURE::character — varying
  • QNA::character — varying
  • NORMAL::character — varying
  • MENTOR::character — varying)::text))
  • is_system — boolean — NOT NULL — 시스템
  • name — varchar(100) — NOT NULL — 권한명
  • permission_type — varchar(20) — NOT NULL — 권한
  • WRITE::character — varying
  • UPDATE::character — varying
  • DELETE::character — varying
  • READ_PRIVATE_INFO::character — varying)::text))

product_policy

  • id — bigint — NOT NULL — 정책
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • lecture_type — varchar(255) — NOT NULL — 강의
  • ONLINE::character — varying
  • STREAMING::character — varying)::text))
  • sort_order — integer — NOT NULL — 정렬
  • title — varchar(255) — NOT NULL — 섹션

product_policy_content

  • id — bigint — NOT NULL — 정책
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • content — varchar(255) — NOT NULL — 내용
  • sort_order — integer — NOT NULL — 정렬
  • policy_id — bigint — NOT NULL — 정책

push_message_template

  • id — bigint — NOT NULL — 메시지
  • message_body — varchar(500) — 푸시
  • message_title — varchar(300) — 푸시
  • url — text — 연결

refresh_token

  • id — bigint — NOT NULL
  • access_token_hash — varchar(255) — NOT NULL — 액세스
  • account_id — bigint — NOT NULL — 사용자
  • expired_at — timestamp(6) — NOT NULL — 만료일시
  • refresh_token — varchar(512) — NOT NULL — 리프레시
  • session_id — varchar(255) — NOT NULL — 세션

role

  • id — bigint — NOT NULL — 역할
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • description — varchar(500) — 역할
  • is_system — boolean — NOT NULL — 시스템
  • level — integer — NOT NULL — 역할
  • name — varchar(50) — NOT NULL — 역할명
  • role_type — varchar(255)
  • MEMBER::character — varying)::text))

role_permission

  • id — bigint — NOT NULL — 역할-권한
  • permission_id — bigint — NOT NULL — 권한
  • role_id — bigint — NOT NULL — 역할

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

session_mentor

  • id — bigint — NOT NULL — 세션-강사
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • lecture_id — bigint — NOT NULL — 강의
  • member_id — bigint — NOT NULL — 강사
  • session_id — bigint — NOT NULL — 세션

survey_form

  • id — bigint — NOT NULL — 설문조사
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • chapter_id — bigint — 섹션
  • entry_id — varchar(255) — NOT NULL — 구글폼
  • form_url — varchar(255) — NOT NULL — 폼
  • google_form_id — varchar(255) — NOT NULL — 구글폼

survey_response

  • id — bigint — NOT NULL — 설문조사
  • chapter_id — bigint
  • lecture_id — bigint
  • member_id — bigint — NOT NULL
  • raw_payload — text
  • submitted_at — timestamp(6) — NOT NULL
  • survey_form_id — bigint — NOT NULL

web_message_template

  • id — bigint — NOT NULL — 메시지
  • message_body — varchar(500) — 웹
  • message_title — varchar(300) — 웹
  • url — text — 연결
  • account_type — varchar(255) — NOT NULL
  • ADMIN::character — varying)::text))
  • event_type — varchar(255) — NOT NULL
  • BROADCAST::character — varying)::text))
  • profile_type — varchar(255) — NOT NULL
  • MENTOR::character — varying)::text))

withdraw_account

  • id — bigint — NOT NULL
  • created_at — timestamp(6) — NOT NULL — 생성일
  • deleted_at — timestamp(6) — 삭제일
  • updated_at — timestamp(6) — 수정일
  • account_type — varchar(255) — NOT NULL — 계정
  • MENTOR::character — varying
  • ADMIN::character — varying)::text))
  • address — varchar(255) — 상세
  • auth_provider_type — varchar(255) — NOT NULL — 인증
  • NAVER::character — varying
  • KAKAO::character — varying
  • APPLE::character — varying
  • LOCAL::character — varying)::text))
  • birth — timestamp(6) — 사용자
  • email — varchar(255) — NOT NULL — 이메일
  • experience_year — timestamp(6) — 경력
  • gender — varchar(255) — 사용자
  • FEMALE::character — varying)::text))
  • identity_ci_hash — varchar(255) — NOT NULL — 계정
  • login_id — varchar(72) — NOT NULL — 로그인
  • 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 — 사용자
  • national_type — varchar(255) — 사용자
  • FOREIGN::character — varying)::text))
  • nickname — varchar(20) — 사용자
  • phone_number — varchar(255) — NOT NULL — 연락처
  • profile_image_url — varchar(255) — 사용자
  • social_provider_id — varchar(255) — 소셜
  • street — varchar(255) — 도로명
  • zip_code — varchar(255) — 우편번호