테스트
테이블 (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) — 우편번호