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)