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