odysseylab

Tables (39)

t_admin_account (관리자 계정(t_admin_credential과 차이를 모르겠음))

  • uuid (Key) — varchar(36) — Primary key — NOT NULL
  • created_at (Field1) — datetime(6) — Extra : DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — Extra : DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL

t_admin_credential (관리자 계정 정보(변경일자,생성일자,삭제여부,id,패스워드)

  • account_uuid (Key) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6)
  • username (Field4) — varchar(255)
  • password (Field5) — varchar(255)

t_admin_sign (관리자 페이지 로그인 내역)

  • id (Key) — int unsigned — Primary key — NOT NULL — Extra : auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — Extra : DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • account_uuid (Field4) — varchar(255)
  • refresh_token (Field5) — varchar(255) — NOT NULL

t_app_config ((모르겠음))

  • code (Key) — varchar(255) — Primary key — NOT NULL — Extra : auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — Extra : DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field4) — varchar(255)

t_biz_category (비즈니스 종류(ex : 한식,치킨))

  • account_uuid (Key) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • code (Field4) — varchar(255)
  • version (Field5) — varchar(255)
  • name (Field6) — varchar(255)
  • priority (Field7) — int — NOT NULL

t_biz_location (우리나라 지역 이름(비즈니스 할 위치))

  • code (Key) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • name (Field6) — varchar(255)
  • priority (Field7) — int — NOT NULL

t_code_spec (????)

  • id (Key) — int_unsigned — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • name (Field6) — varchar(255)
  • priority (Field7) — int — NOT NULL

t_doc_analysis_estimation (phase(ENTRY,OPERATION,EXIT))

  • uuid (Key) — varchar(36) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • step (Field6) — varchar(255)
  • phase (Field7) — varchar(255) — NOT NULL
  • value (Field4) — decimal(10,6)
  • requistion_code (Field8) — varchar(255)
  • requisition_record_key (Field9) — varchar(255)
  • report_code (Field10) — varchar(255)

t_doc_analysis_report (문의제목(진입리스크,운영리스크,exit리스크))

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • title (Field6) — varchar(255)
  • entry_risk (Field7) — decimal(10,6) — NOT NULL
  • operation_risk (Field4) — decimal(10,6)
  • exit_risk (Field8) — decimal(10,6)

t_doc_analysis_report_media (업로드 파일 위치 같음 ???)

  • report_code (Key) — varchar(255) — Primary key — NOT NULL
  • type (Key2) — varchar(255) — Primary key — NOT NULL
  • seq (Key3) — int — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • meta_uuid (Field6) — varchar(255)
  • url (Field7) — varchar(500) — NOT NULL
  • media_type (Field4) — varchar(255)
  • is_primary (Field8) — tinyint
  • file_name (Field9) — varchar(255)

t_doc_analysis_requisition (문의 내용(가맹,상가,정보) -> 템플릿(Lease_store,프랜차이즈,infromation disclosure))

  • code (Key) — varchar(255) — Primary key — NOT NULL
  • report_code (Unique) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field6) — varchar(255)
  • account_uuid (Field7) — varchar(255) — NOT NULL
  • title (Field4) — varchar(255)
  • status (Field8) — varchar(255)
  • submitted_at (Field9) — datetime
  • doc_template_code (Field10) — varchar(255)
  • doc_template_name (Field5) — varchar(255)
  • doc_template_version (Field11) — varchar(255)
  • biz_category_code (Field12) — varchar(255)
  • biz_location_code (Field13) — varchar(255)
  • report_code (Field14) — varchar(255)

t_doc_analysis_requisition_establishment_info (문의내용 -> 연결 -> ( 진행단계,연결 정보))

  • requisition_code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • step_info (Field5) — varchar(255) — NOT NULL
  • experience_count_info (Field6) — varchar(255)
  • work_experience_period_info (Field7) — varchar(255) — NOT NULL
  • age_info (Field4) — varchar(255)
  • gender_info (Field8) — varchar(255)

t_doc_analysis_requisition_media (문의내용 -> 올린 media 위치,정보 등..)

  • requisition_code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • seq (Key2) — int — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • meta_uuid (Field5) — varchar(255) — NOT NULL
  • url (Field6) — varchar(500)
  • media_type (Field7) — varchar(255) — NOT NULL
  • is_primary (Field4) — tinyint
  • file_name (Field8) — varchar(255)

t_doc_analysis_requisition_record (문의 내용 질문 템플릿)

  • requisition_code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • Key (Key2) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • template_item_code (Field5) — varchar(255) — NOT NULL
  • label (Field6) — varchar(255)
  • value (Field7) — varchar(255) — NOT NULL

t_doc_analysis_rule_sheet (분석자료(score,weight 등...)?????)

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • phase (Field6) — varchar(255)
  • range_from (Field7) — int — NOT NULL
  • range_to (Field4) — int
  • score (Field8) — decimal(10,6)
  • weight (Field9) — decimal(10,6)
  • priority (Field10) — int
  • Field11

t_doc_analysis_rule_sheet_map (template item code, rule_sheet code4 위치 등...)

  • rule_sheet_code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • rule_sheet_version (Key2) — varchar(100) — Primary key — NOT NULL
  • template_item_code (Key3) — varchar(255) — Primary key — NOT NULL
  • option_key (Key4) — varchar(100) — Primary key — NOT NULL
  • step (Field) — int — DEFAULT_GENERATED
  • evaluation (Field2) — varchar(255) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)

t_doc_analysis_scan (분석 스캔?? (media_key,code,requisition_code))

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • requistion_code (Field6) — varchar(255)
  • media_seq (Field7) — int — NOT NULL
  • media_key (Field4) — varchar(255)
  • meta (Field8) — json

t_doc_analysis_scan_block (????????)

  • uuid (Key) — varchar(36) — Primary key — NOT NULL — auto_increment
  • scan_code (MUL) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • type (Field5) — varchar(255) — NOT NULL
  • no (Field6) — int
  • title (Field7) — varchar(255) — NOT NULL
  • parent_uuid (Field4) — varchar(255)

t_doc_analysis_scan_line (??)

  • uuid (Key) — varchar(36) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • scan_code (Field5) — varchar(255) — NOT NULL
  • text (Field6) — text
  • page_no (Field7) — int — NOT NULL
  • offset (Field4) — decimal(10,6)
  • block_uuid (Field8) — varchar(255) — NOT NULL

t_doc_template (분석 관리 > 문서양식)

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • name (Field6) — varchar(255)
  • base_score (Field7) — decimal(10,6) — NOT NULL
  • priority (Field4) — int

t_doc_template_item (분석관리 > 문서양식 > 양식별 상세내역)

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • templat_code (Field6) — varchar(255)
  • seq (Field7) — int — NOT NULL
  • section_no (Field4) — int
  • label (Field8) — varchar(300)
  • unit (Field9) — varchar(255)
  • is_required (Field10) — tinyint
  • data_type (Field11) — varchar(255)
  • input_type (Field12) — varchar(255)
  • example (Field13) — varchar(255)

t_doc_template_item_keyword (분석관리 > 문서양식 > 양식별 상세내역에서 키워드 정의)

  • item_code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • seq (Key2) — int — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • text (Field5) — varchar(255) — NOT NULL
  • is_primary (Field6) — tinyint

t_doc_template_item_option (의뢰내역 > section 2 > (분석관리>문서양식>양식별 상세내역)에 대한 분석(있음,없음))

  • item_code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • key (Key2) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • label (Field5) — varchar(255) — NOT NULL
  • no (Field6) — int

t_doc_template_section (??(비용,계약문구) - (프랜차이즈,lease_Store,information_disclosure))

  • templat_code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • no (Key2) — int — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • title (Field5) — varchar(255) — NOT NULL
  • description (Field6) — varchar(255)

t_inquiry (문의 내역(작성자-제목-내용 등..))

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • type (Field6) — varchar(255)
  • email (Field7) — varchar(255) — NOT NULL
  • phone (Field4) — varchar(255)
  • title (Field8) — varchar(3000)
  • reply (Field9) — varchar(5000)
  • writer_name (Field10) — varchar(255)
  • writer_account_uuid (Field11) — varchar(255)

t_media_meta (media 메타 데이터)

  • uuid (Key) — varchar(36) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • svc (Field5) — varchar(255) — NOT NULL
  • volume_code (Field6) — varchar(255)
  • mime_type (Field7) — varchar(255) — NOT NULL
  • file_name (Field4) — varchar(255)
  • size (Field8) — int
  • url (Field9) — varchar(255)
  • key (Field10) — varchar(255)
  • media_type (Field11) — varchar(255)
  • device_type (Field12) — varchar(255)
  • is_public (Field13) — tinyint
  • file_meta (Field14) — json
  • payload (Field15) — json

t_media_volume (???(???))

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL
  • svc (Field6) — varchar(255)
  • name (Field7) — varchar(255) — NOT NULL
  • description (Field4) — varchar(255)
  • status (Field8) — varchar(255)
  • storage (Field9) — varchar(255)
  • location (Field10) — varchar(255)
  • limit (Field11) — int
  • used (Field12) — int

t_site_odysseylab_user (유저 정보(마케팅 정보,location 포함))

  • account_uuid (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • location_code (Field5) — varchar(255) — NOT NULL
  • referral_type (Field6) — varchar(255)
  • marketing_notification_transports (Field4) — varchar(500)

t_sys_config (t)

  • code (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • version (Field5) — varchar(255) — NOT NULL

t_transmission_email (이메일 인증)

  • uuid (Key) — varchar(36) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • http_request_url (Field5) — varchar(300) — NOT NULL
  • http_request_header (Field4) — varchar(300)
  • http_request_payload (Field6) — varchar(1000)
  • http_status_code (Field7) — int
  • http_response_payload (Field8) — varchar(500)
  • http_error_payload (Field9) — varchar(500)
  • status (Field10) — varchar(255)
  • subject (Field11) — varchar(255)
  • body (Field12) — text
  • message_id (Field13) — varchar(255)
  • provider (Field14) — varchar(255)
  • server_host (Field15) — varchar(255)
  • sender_address (Field16) — varchar(255)
  • is_html_body (Field17) — tinyint
  • template (Field18) — varchar(255)

t_transmission_email_attachment (CopyOft)

  • transmission_uuid (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • seq (Key2) — int — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL

t_transmission_email_recipient (CopyOfCopyOft)

  • transmission_uuid (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • seq (Key2) — int — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • is_cc (Field4) — tinyint
  • address (Field5) — varchar(255)
  • template_data (Field6) — json

t_user_account (CopyOfCopyOfCopyOft)

  • uuid (Key) — varchar(36) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • suspended_at (Field4) — datetime
  • is_official (Field5) — tinyint

t_user_agreement (CopyOfCopyOfCopyOfCopyOft)

  • account_uuid (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • seq (Key2) — int — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • is_service_term_agreed (Field4) — tinyint
  • is_privacy_term_agreed (Field5) — tinyint
  • is_marketing_term_agreed (Field6) — tinyint

t_user_credential (CopyOfCopyOfCopyOfCopyOfCopyOft)

  • account_uuid (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • seq (Key2) — int — Primary key — NOT NULL
  • auth_type (Key3) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • is_primary (Field4) — tinyint
  • username (Field5) — varchar(255)
  • password (Field6) — varchar(255)
  • email (Field7) — varchar(255)
  • phone (Field8) — varchar(255)
  • google_id (Field9) — varchar(255)
  • facebook_id (Field10) — varchar(255)
  • kakao_id (Field11) — varchar(255)
  • apple_id (Field12) — varchar(255)
  • naver_id (Field13) — varchar(255)

t_user_profile (23)

  • account_uuid (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • code (Unique) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • inviation_code (Field4) — varchar(255)
  • ci (Field5) — varchar(255)
  • phone (Field6) — varchar(255)
  • email (Field7) — varchar(255)
  • birth (Field8) — varchar(255)
  • gender (Field9) — varchar(255)
  • is_hidden (Field10) — tinyint
  • fcm_token (Field11) — varchar(255)

t_user_profile_history (CopyOf23)

  • account_uuid (Key) — varchar(255) — Primary key — NOT NULL — auto_increment
  • code (Unique) — varchar(255) — Primary key — NOT NULL
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • inviation_code (Field4) — varchar(255)
  • ci (Field5) — varchar(255)
  • phone (Field6) — varchar(255)
  • email (Field7) — varchar(255)
  • birth (Field8) — varchar(255)
  • gender (Field9) — varchar(255)
  • is_hidden (Field10) — tinyint
  • fcm_token (Field11) — varchar(255)

t_user_sign (CopyOfCopyOf23)

  • id (Key) — int unsigned — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • auth_type (Field4) — varchar(255)
  • reresh_token (Field5) — varchar(255)
  • fcm_token (Field6) — varchar(255)
  • fcm_token (Field7) — varchar(255)
  • is_signup (Field8) — tinyint

t_user_verification (CopyOfCopyOfCopyOf23)

  • uuid (Key) — varchar(36) — Primary key — NOT NULL — auto_increment
  • created_at (Field) — datetime(6) — DEFAULT_GENERATED
  • updated_at (Field2) — datetime(6) — DEFAULT_GENERATED on update CURRENT_TIMESTAMP(6)
  • deleted_at (Field3) — datetime(6) — NOT NULL
  • verification_code (Field4) — varchar(255)
  • phone (Field5) — varchar(255)
  • email (Field6) — varchar(255)
  • identity (Field7) — varchar(255)
  • verified_at (Field8) — datetime
  • account_uuid (Field9) — varchar(255)
  • expries_at (Field10) — datetime