Cropper 보고용 ERD

테이블 (12)

crp_chat

  • page_id — int4 — 기본 키 — NOT NULL
  • chat_id — int4 — 기본 키 — NOT NULL
  • speaker — int2 — NOT NULL
  • content — text — NOT NULL
  • crt_time — timestamp

crp_image

  • page_id — int4 — 기본 키 — NOT NULL
  • image_id — int4 — 기본 키 — NOT NULL
  • file_base64 — text — NOT NULL
  • ocr_script — text
  • crt_time — timestamp

crp_m_project_module

  • project_id — int4 — 기본 키 — NOT NULL
  • module_id — int4 — 기본 키 — NOT NULL

crp_module

  • module_id — int4 — 기본 키 — NOT NULL
  • name — varchar(10) — NOT NULL
  • description — varchar(200)
  • icon — varchar(10)

crp_ocr_usage

  • uuid — varchar(40)
  • user_uid — varchar(40)
  • ocr_type — varchar(40)
  • response — text
  • crt_time — timestamp
  • page_id — int4
  • image_id — int4

crp_page

  • page_id — int4 — 기본 키 — NOT NULL
  • project_id — int4 — NOT NULL
  • title — varchar(20) — NOT NULL
  • file_type — int2
  • crt_time — timestamp
  • mod_time — timestamp
  • summary_file — text
  • model_name — varchar(30) — NOT NULL

crp_payment_transactions

  • id — bigserial — 기본 키 — NOT NULL
  • user_uid — varchar(40) — NOT NULL
  • amount — numeric(10, 2) — NOT NULL
  • currency — varchar(10)
  • status — varchar(20) — NOT NULL
  • payment_method — varchar(50) — NOT NULL
  • provider — varchar(50)
  • external_id — varchar(100)
  • requested_at — timestamp — NOT NULL
  • confirmed_at — timestamp
  • refunded_amount — numeric(10, 2)
  • refunded_at — timestamp
  • refund_reason — text
  • metadata — jsonb
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • success::character — varying
  • failed::character — varying
  • cancelled::character — varying)::text)))

crp_project

  • project_id — int4 — 기본 키 — NOT NULL
  • user_uid — varchar(40) — NOT NULL
  • title — varchar(20) — NOT NULL
  • crt_time — timestamp
  • mod_time — timestamp
  • style — int2

crp_token_usage

  • uuid — varchar(40)
  • user_uid — varchar(40)
  • llm_type — varchar(40)
  • response — text
  • crt_time — timestamp
  • mod_time — timestamp
  • input_token — int4
  • output_token — int4
  • prompt — jsonb
  • page_id — int4

crp_usage_rates

  • id — int4 — 기본 키 — NOT NULL
  • service_type — varchar(50) — NOT NULL
  • unit — varchar(20) — NOT NULL
  • rate_per_unit — numeric(10, 6) — NOT NULL
  • currency — varchar(10) — NOT NULL
  • is_active — bool — NOT NULL
  • effective_from — timestamp — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp — NOT NULL
  • engine_name — varchar(40)

crp_user_wallets

  • user_uid — varchar(40) — 기본 키 — NOT NULL
  • balance — int4 — NOT NULL
  • updated_at — timestamp — NOT NULL

t_user

  • user_uid — varchar(40) — 기본 키 — NOT NULL
  • user_id — varchar(200) — NOT NULL
  • user_type — bpchar(1)
  • user_past_pwd1 — varchar(400)
  • user_past_pwd2 — varchar(400)
  • user_pwd — varchar(400) — NOT NULL
  • user_name — varchar(200) — NOT NULL
  • user_email — varchar(30) — NOT NULL
  • wd_yn — bpchar(1) — NOT NULL
  • wd_time — timestamp
  • rec_connect — timestamp
  • del_yn — bpchar(1) — NOT NULL
  • etc_1 — varchar(400)
  • etc_2 — varchar(400)
  • etc_3 — varchar(400)
  • etc_4 — varchar(400)
  • crt_time — timestamptz
  • crt_by — varchar(100)
  • mod_time — timestamp
  • mod_by — varchar(100)