plyn

테이블 (24)

categories_전역분류택소노미

  • id — CHAR(36) — 기본 키 — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • parent_code_자기참조트리 — VARCHAR(64) — 외래 키 → categories_전역분류택소노미.code
  • level — INT — NOT NULL
  • is_leaf — BOOLEAN — NOT NULL
  • scheme_코드체계 — VARCHAR(32) — NOT NULL
  • sort_order — INT — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

classification_runs_분류실행감사

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • batch_id — CHAR(36) — 외래 키 → upload_batches_지출업로드배치.id — NOT NULL
  • run_key_멱등키 — VARCHAR(64)
  • status — VARCHAR(32) — NOT NULL
  • source — VARCHAR(32)
  • total_count — INT — NOT NULL
  • classified_count — INT — NOT NULL
  • manual_count — INT — NOT NULL
  • failed_count — INT — NOT NULL
  • error_summary — JSON
  • started_at — DATETIME
  • finished_at — DATETIME
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

integrity_findings

  • id — CHAR(36) — 기본 키 — NOT NULL
  • ran_at — DATETIME — NOT NULL
  • relation — VARCHAR(128) — NOT NULL
  • org_id — CHAR(36)
  • hard — INT — NOT NULL
  • dangling — INT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_available — BOOLEAN — NOT NULL
  • deleted_at — DATETIME

invitations_멤버초대

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • role_code — VARCHAR(64) — 외래 키 → roles_역할.code — NOT NULL
  • token — VARCHAR(128) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • invited_by — CHAR(36) — 외래 키 → members_조직구성원.id
  • accepted_at — DATETIME
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

jobs_작업큐

  • id — CHAR(36) — 기본 키 — NOT NULL
  • domain_라우팅키 — VARCHAR(32) — NOT NULL
  • task_도메인내작업명 — VARCHAR(64) — NOT NULL
  • payload — JSON — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • attempts — INT — NOT NULL
  • max_attempts — INT — NOT NULL
  • available_at — DATETIME — NOT NULL
  • locked_at — DATETIME
  • locked_by — VARCHAR(64)
  • last_error — VARCHAR(1000)
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

members_조직구성원

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • cognito_sub — VARCHAR(128) — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • role_code — VARCHAR(64) — 외래 키 → roles_역할.code — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME
  • team_id — CHAR(36) — 외래 키 → teams_조직하위그룹.id
  • name_성명 — VARCHAR(80)
  • phone_휴대폰 — VARCHAR(40)
  • department_부서직급 — VARCHAR(120)
  • position_직급 — VARCHAR(80)
  • terms_agreed_at_약관동의시각 — DATETIME
  • privacy_agreed_at — DATETIME

menus_자기참조메뉴트리

  • id — CHAR(36) — 기본 키 — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • parent_code_자기참조menus — VARCHAR(64) — 외래 키 → menus_자기참조메뉴트리.code
  • label — VARCHAR(100) — NOT NULL
  • path — VARCHAR(255)
  • icon — VARCHAR(64)
  • sort_order — INT — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

organizations_테넌트루트

  • id — CHAR(36) — 기본 키 — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • client_type — VARCHAR(32) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME
  • business_number_계정키 — VARCHAR(20)
  • vendor_profile — JSON
  • representative_대표자 — VARCHAR(80)
  • industry_업종 — VARCHAR(120)
  • address_주소 — VARCHAR(300)
  • representative_phone_대표전화 — VARCHAR(40)
  • hq_address_본사주소 — VARCHAR(300)
  • factory_address_공장주소 — VARCHAR(300)
  • business_area_사업영역 — VARCHAR(200)
  • products_주요제품 — VARCHAR(300)

role_menus_역할메뉴

  • id — CHAR(36) — 기본 키 — NOT NULL
  • role_code — VARCHAR(64) — 외래 키 → roles_역할.code — NOT NULL
  • menu_code — VARCHAR(64) — 외래 키 → menus_자기참조메뉴트리.code — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

role_permissions_역할권한

  • id — CHAR(36) — 기본 키 — NOT NULL
  • role_code — VARCHAR(64) — 외래 키 → roles_역할.code — NOT NULL
  • permission — VARCHAR(100) — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

roles_역할

  • id — CHAR(36) — 기본 키 — NOT NULL
  • code — VARCHAR(64) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • scope — VARCHAR(16) — NOT NULL
  • description — VARCHAR(255)
  • is_system — BOOLEAN — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

savings_opportunities_절감대상

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • run_id — CHAR(36) — 외래 키 → savings_runs_절감발굴실행감사.id — NOT NULL
  • item_id — CHAR(36) — 외래 키 → spend_items_정규화지출품목.id — NOT NULL
  • category_code — VARCHAR(64) — 외래 키 → categories_전역분류택소노미.code
  • current_unit_price_현행지출스냅샷 — DECIMAL(18,4)
  • quantity — DECIMAL(18,4)
  • current_amount — DECIMAL(18,4)
  • currency — VARCHAR(8) — NOT NULL
  • supplier_name — VARCHAR(200)
  • baseline_price_판정필드 — DECIMAL(18,4)
  • est_saving_rate — DECIMAL(6,4)
  • est_saving_amount — DECIMAL(18,4)
  • is_recommended — BOOLEAN — NOT NULL
  • benchmark_source — VARCHAR(16) — NOT NULL
  • ops_status_양방향선정상태 — VARCHAR(16) — NOT NULL
  • member_status — VARCHAR(16) — NOT NULL
  • selected_at — DATETIME
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

savings_runs_절감발굴실행감사

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • batch_id — CHAR(36) — 외래 키 → upload_batches_지출업로드배치.id — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • source — VARCHAR(32)
  • total_count — INT — NOT NULL
  • recommended_count — INT — NOT NULL
  • below_threshold_count — INT — NOT NULL
  • no_benchmark_count — INT — NOT NULL
  • error_summary — JSON
  • started_at — DATETIME
  • finished_at — DATETIME
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

sourcing_contacts_공급사담당자

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_운영사테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • vendor_id — CHAR(36) — 외래 키 → sourcing_vendors_공급사Pool.id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • phone — VARCHAR(50)
  • email — VARCHAR(255)
  • role — VARCHAR(50)
  • is_primary — BOOLEAN — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

sourcing_entries_공급사Pool진입신청

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_운영사테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • business_number_신청사업자번호 — VARCHAR(32) — NOT NULL
  • source — VARCHAR(16) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • vendor_id_승인시편입연결된vend — CHAR(36) — 외래 키 → sourcing_vendors_공급사Pool.id
  • applicant_org_id_자가신청공급사autho — CHAR(36) — 외래 키 → organizations_테넌트루트.id
  • decided_at — DATETIME
  • note — VARCHAR(500)
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

sourcing_introduction_records_소개사실기록

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_운영사테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • buyer_org_id_소개된구매기업 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • vendor_id — CHAR(36) — 외래 키 → sourcing_vendors_공급사Pool.id — NOT NULL
  • vendor_org_id_소개시점의공급사auth — CHAR(36) — 외래 키 → organizations_테넌트루트.id
  • opportunity_id — CHAR(36) — 외래 키 → savings_opportunities_절감대상.id
  • item_id — CHAR(36) — 외래 키 → spend_items_정규화지출품목.id
  • category_code — VARCHAR(64) — 외래 키 → categories_전역분류택소노미.code
  • spec_snapshot_소개시점normaliz — JSON
  • match_id — CHAR(36) — 외래 키 → sourcing_matches_절감대상후보공급사매칭.id
  • rfq_request_id — CHAR(36)
  • channel — VARCHAR(24) — NOT NULL
  • event_kind — VARCHAR(24) — NOT NULL
  • event_at_사실발생시각 — DATETIME — NOT NULL
  • actor_member_id — CHAR(36) — 외래 키 → members_조직구성원.id
  • evidence_key — VARCHAR(512)
  • note — VARCHAR(500)
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

sourcing_matches_절감대상후보공급사매칭

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_운영사테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • round_id_산출회차 — CHAR(36) — 외래 키 → sourcing_rounds_소싱회차.id
  • opportunity_id — CHAR(36) — 외래 키 → savings_opportunities_절감대상.id — NOT NULL
  • category_code — VARCHAR(64) — 외래 키 → categories_전역분류택소노미.code
  • vendor_id_후보공급사 — CHAR(36) — 외래 키 → sourcing_vendors_공급사Pool.id
  • score — DECIMAL(6,4)
  • match_source — VARCHAR(16) — NOT NULL
  • rank — INT
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

sourcing_rounds_소싱회차

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_운영사테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • round_no_실증고정1 — INT — NOT NULL
  • target_key_정렬된opportuni — VARCHAR(64) — NOT NULL
  • target_count — INT — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • source — VARCHAR(16) — NOT NULL
  • match_count — INT — NOT NULL
  • error_summary_폴백실패근거 — JSON
  • started_at — DATETIME
  • finished_at — DATETIME
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

sourcing_specs_Spec표준화산출

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_운영사테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • opportunity_id — CHAR(36) — 외래 키 → savings_opportunities_절감대상.id — NOT NULL
  • item_id — CHAR(36) — 외래 키 → spend_items_정규화지출품목.id
  • category_code — VARCHAR(64) — 외래 키 → categories_전역분류택소노미.code
  • source_spec_text_회원사규격원본 — TEXT
  • attachment_key_도면성적서저장키 — VARCHAR(512)
  • normalized_spec_운영사표준화결과 — JSON
  • spec_source — VARCHAR(16) — NOT NULL
  • status — VARCHAR(16) — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

sourcing_vendors_공급사Pool

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_운영사테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • business_number_계정매칭키 — VARCHAR(32) — NOT NULL
  • company_name — VARCHAR(200) — NOT NULL
  • representative_프로필 — VARCHAR(100)
  • address — VARCHAR(300)
  • industry — VARCHAR(100)
  • scale — VARCHAR(50)
  • main_trade — VARCHAR(200)
  • certifications — VARCHAR(300)
  • note — VARCHAR(1000)
  • linked_org_id_가입공급사authVEN — CHAR(36) — 외래 키 → organizations_테넌트루트.id
  • status — VARCHAR(16) — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

spend_items_정규화지출품목

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • batch_id — CHAR(36) — 외래 키 → upload_batches_지출업로드배치.id — NOT NULL
  • row_no_원본행번호 — INT — NOT NULL
  • raw_원본행무손실 — JSON — NOT NULL
  • item_name — VARCHAR(300)
  • spec — VARCHAR(500)
  • quantity — DECIMAL(18,4)
  • unit — VARCHAR(32)
  • unit_price — DECIMAL(18,4)
  • amount — DECIMAL(18,4)
  • currency — VARCHAR(8) — NOT NULL
  • supplier_name — VARCHAR(200)
  • purchased_at — DATE
  • category_code_분류결과주입슬롯 — VARCHAR(64) — 외래 키 → categories_전역분류택소노미.code
  • classification_status — VARCHAR(32) — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME
  • source_item_code_회원사원천품목코드 — VARCHAR(128)
  • source_supplier_code_회원사원천거래처코드 — VARCHAR(64)
  • raw_category_l1_회원사자체분류대중소이름 — VARCHAR(200)
  • raw_category_l2 — VARCHAR(200)
  • raw_category_l3 — VARCHAR(200)
  • supplier_biz_no_거래처사업자번호 — VARCHAR(20)
  • vat_amount_부가세 — DECIMAL(18,4)
  • received_quantity_입고단위기준수량 — DECIMAL(18,4)
  • received_unit_입고단위 — VARCHAR(32)

teams_조직하위그룹

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

upload_batches_지출업로드배치

  • id — CHAR(36) — 기본 키 — NOT NULL
  • org_id_테넌트 — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • uploaded_by_sub_업로더cognito — VARCHAR(128) — NOT NULL
  • source_filename — VARCHAR(255) — NOT NULL
  • storage_key — VARCHAR(512)
  • content_type — VARCHAR(100)
  • byte_size — BIGINT
  • row_count — INT — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • error_summary — JSON
  • classification_run_key — VARCHAR(64)
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME

vendor_invitations_공급사

  • id — CHAR(36) — 기본 키 — NOT NULL
  • email — VARCHAR(320) — NOT NULL
  • company_name — VARCHAR(200)
  • business_number — VARCHAR(20)
  • prefill — JSON
  • token — VARCHAR(128) — NOT NULL
  • status — VARCHAR(32) — NOT NULL
  • expires_at — DATETIME — NOT NULL
  • invited_by — CHAR(36) — 외래 키 → members_조직구성원.id
  • issued_by_org_id — CHAR(36) — 외래 키 → organizations_테넌트루트.id — NOT NULL
  • accepted_org_id — CHAR(36) — 외래 키 → organizations_테넌트루트.id
  • accepted_at — DATETIME
  • created_at_생성일시 — DATETIME — NOT NULL
  • updated_at_수정일시 — DATETIME — NOT NULL
  • is_available_사용여부 — BOOLEAN — NOT NULL
  • deleted_at_삭제일시 — DATETIME
  • target_org_id — CHAR(36) — 외래 키 → organizations_테넌트루트.id