syncETA
Tables (12)
action_cost
- id — uuid — Primary key — NOT NULL
- action_code — varchar(20) — NOT NULL
- action_name — varchar(50) — NOT NULL
- cost — integer — NOT NULL
- is_active — boolean — NOT NULL
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
credit_usage
- id — uuid — Primary key — NOT NULL
- workspace_id — uuid — Foreign key → workspace.id — NOT NULL
- project_id — uuid — Foreign key → project.id
- user_id — uuid — NOT NULL
- action_cost_id — uuid — Foreign key → action_cost.id — NOT NULL
- total_cost — integer
- supplied_used — integer
- paid_used — integer
- used_at — timestamptz — NOT NULL
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
prd_package
- id — uuid — Primary key — NOT NULL
- code — varchar(20) — NOT NULL
- name — varchar(50) — NOT NULL
- credit_amount — integer — NOT NULL
- desc — text
- is_active — boolean
- is_visible — boolean
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
pricing_plan
- id — uuid — Primary key — NOT NULL
- code — varchar(20) — NOT NULL
- name — varchar(100) — NOT NULL
- max_project_count — smallint
- max_member_count — smallint
- credit_amount — integer
- price — integer
- billing_cycle — varchar(20)
- is_contact_only — boolean — NOT NULL
- is_default — boolean — NOT NULL
- is_active — boolean — NOT NULL
- is_visible — boolean — NOT NULL
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
project
- id — uuid — Primary key — NOT NULL
- workspace_id — uuid — Foreign key → workspace.id
- title — varchar(100)
- desc — text
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz — NOT NULL
- updated_at — timestamptz
- deleted_at — timestamptz
workspace
- id — uuid — Primary key — NOT NULL
- name — varchar(100) — NOT NULL
- owner_id — uuid — NOT NULL
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
workspace_credit_balance
- id — uuid — Primary key — NOT NULL
- workspace_id — uuid — Foreign key → workspace.id — NOT NULL
- supplied_credit — integer — NOT NULL
- paid_credit — integer — NOT NULL
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
workspace_member
- id — uuid — Primary key — NOT NULL
- workspace_id — uuid — Foreign key → workspace.id — NOT NULL
- user_id — uuid — NOT NULL
- role — varchar(20) — NOT NULL
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
workspace_payment
- id — uuid — Primary key — NOT NULL
- workspace_id — uuid — Foreign key → workspace.id — NOT NULL
- user_id — uuid — NOT NULL
- pg_payment_id — varchar(200) — NOT NULL
- desc — text
- status — varchar(20) — NOT NULL
- prd_type — varchar(20) — NOT NULL
- prd_price — integer
- plan_id — uuid — Foreign key → pricing_plan.id
- plan_code — varchar(20)
- plan_name — varchar(50)
- plan_credit_amount — integer
- package_id — uuid — Foreign key → prd_package.id
- package_code — varchar(20)
- package_name — varchar(50)
- package_credit_amount — integer
- payment_at — timestamptz — NOT NULL
- changed_at — timestamptz
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
workspace_payment_history
- id — uuid — Primary key — NOT NULL
- workspace_payment_id — uuid — Foreign key → workspace_payment.id — NOT NULL
- status — varchar(20) — NOT NULL
- failure_code — varchar(20)
- desc — text
- source — varchar(20)
- admin_id — uuid
- changed_at — timestamptz
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
workspace_subscription
- id — uuid — Primary key — NOT NULL
- workspace_id — uuid — Foreign key → workspace.id — NOT NULL
- plan_id — uuid — Foreign key → pricing_plan.id — NOT NULL
- status — varchar(20) — NOT NULL
- period_start — timestamptz — NOT NULL
- period_end — timestamptz — NOT NULL
- pending_plan_id — uuid — Foreign key → pricing_plan.id
- pg_subscription_id — varchar(200)
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz
workspace_subscription_history
- id — uuid — Primary key — NOT NULL
- workspace_id — uuid — Foreign key → workspace.id — NOT NULL
- from_plan_id — uuid — Foreign key → pricing_plan.id
- to_plan_id — uuid — Foreign key → pricing_plan.id
- event_type — varchar(20) — NOT NULL
- payment_history_id — uuid — Foreign key → workspace_payment_history.id
- event_at — timestamptz — NOT NULL
- sort — int
- del_yn — varchar(1) — NOT NULL
- created_by — uuid
- updated_by — uuid
- deleted_by — uuid
- created_at — timestamptz
- updated_at — timestamptz
- deleted_at — timestamptz