patty-web

Tables (18)

activity_logs

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • action — VARCHAR — NOT NULL — action
  • admin_id — VARCHAR — admin_id
  • created_at — VARCHAR — 생성 시간
  • description — VARCHAR — 설명
  • ip_address — INET — ip_address
  • new_values — JSONB — new_values
  • old_values — JSONB — old_values
  • resource_id — VARCHAR — resource_id
  • resource_type — VARCHAR — resource_type
  • session_id — VARCHAR — session_id
  • user_agent — VARCHAR — user_agent

admins

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • admin_role — VARCHAR — NOT NULL — admin_role
  • can_access_analytics — BOOLEAN — can_access_analytics
  • can_manage_admins — BOOLEAN — can_manage_admins
  • can_manage_billing — BOOLEAN — can_manage_billing
  • can_manage_content — BOOLEAN — can_manage_content
  • can_manage_products — BOOLEAN — can_manage_products
  • can_manage_support — BOOLEAN — can_manage_support
  • can_manage_users — BOOLEAN — can_manage_users
  • created_at — VARCHAR — 생성 시간
  • created_by — VARCHAR — 생성자 ID
  • department — VARCHAR — department
  • email — VARCHAR — NOT NULL — 이메일 주소
  • failed_login_attempts — DECIMAL — failed_login_attempts
  • full_name — VARCHAR — full_name
  • is_active — BOOLEAN — 활성화 여부
  • last_failed_login_at — VARCHAR — last_failed_login_at
  • last_login_at — VARCHAR — last_login_at
  • login_count — DECIMAL — login_count
  • password_changed_at — VARCHAR — password_changed_at
  • password_hash — VARCHAR — NOT NULL — 비밀번호 해시
  • permissions — JSONB — permissions
  • updated_at — VARCHAR — 수정 시간
  • username — VARCHAR — NOT NULL — 사용자명

ai_categories

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • created_at — VARCHAR — 생성 시간
  • description — VARCHAR — 설명
  • description_ko — VARCHAR — description_ko
  • icon_url — VARCHAR — icon_url
  • is_active — BOOLEAN — 활성화 여부
  • name — VARCHAR — NOT NULL — 이름
  • name_ko — VARCHAR — name_ko
  • slug — VARCHAR — NOT NULL — URL 친화적 식별자
  • sort_order — DECIMAL — sort_order
  • updated_at — VARCHAR — 수정 시간

ai_products

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • api_endpoint — VARCHAR — api_endpoint
  • base_price — DECIMAL — base_price
  • category_id — VARCHAR — category_id
  • created_at — VARCHAR — 생성 시간
  • created_by — VARCHAR — 생성자 ID
  • credit_billing_type — VARCHAR — credit_billing_type
  • credit_cost — DECIMAL — credit_cost
  • demo_url — VARCHAR — demo_url
  • description — VARCHAR — 설명
  • description_ko — VARCHAR — description_ko
  • is_active — BOOLEAN — 활성화 여부
  • is_featured — BOOLEAN — is_featured
  • metadata — JSONB — 메타데이터
  • name — VARCHAR — NOT NULL — 이름
  • name_ko — VARCHAR — name_ko
  • pricing_type — VARCHAR — pricing_type
  • rating_avg — DECIMAL — rating_avg
  • rating_count — DECIMAL — rating_count
  • short_description — VARCHAR — short_description
  • short_description_ko — VARCHAR — short_description_ko
  • slug — VARCHAR — NOT NULL — URL 친화적 식별자
  • status — VARCHAR — 상태
  • tags — VARCHAR — tags
  • thumbnail_url — VARCHAR — thumbnail_url
  • updated_at — VARCHAR — 수정 시간
  • usage_count — DECIMAL — usage_count
  • view_count — DECIMAL — view_count

api_keys

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • allowed_ips — INET — allowed_ips
  • context_type — TEXT — NOT NULL — context_type
  • created_at — VARCHAR — 생성 시간
  • description — VARCHAR — 설명
  • expires_at — VARCHAR — expires_at
  • is_active — BOOLEAN — 활성화 여부
  • key_hash — VARCHAR — NOT NULL — key_hash
  • key_prefix — VARCHAR — NOT NULL — key_prefix
  • last_used_at — VARCHAR — last_used_at
  • name — VARCHAR — NOT NULL — 이름
  • organization_id — VARCHAR — 조직 ID
  • permissions — VARCHAR — permissions
  • rate_limit_per_day — DECIMAL — rate_limit_per_day
  • rate_limit_per_hour — DECIMAL — rate_limit_per_hour
  • rate_limit_per_minute — DECIMAL — rate_limit_per_minute
  • updated_at — VARCHAR — 수정 시간
  • usage_count — DECIMAL — usage_count
  • user_id — VARCHAR — 사용자 ID

credit_transactions

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • amount — DECIMAL — NOT NULL — 금액
  • balance_after — DECIMAL — balance_after
  • balance_before — DECIMAL — balance_before
  • context_type — TEXT — NOT NULL — context_type
  • created_at — VARCHAR — 생성 시간
  • description — VARCHAR — 설명
  • metadata — JSONB — 메타데이터
  • organization_id — VARCHAR — 조직 ID
  • payment_reference — VARCHAR — payment_reference
  • reference_id — VARCHAR — reference_id
  • status — VARCHAR — 상태
  • type — VARCHAR — NOT NULL — 타입
  • user_id — VARCHAR — 사용자 ID

notifications

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • action_label — VARCHAR — action_label
  • action_url — VARCHAR — action_url
  • context_type — TEXT — context_type
  • created_at — VARCHAR — 생성 시간
  • expires_at — VARCHAR — expires_at
  • is_read — BOOLEAN — is_read
  • message — VARCHAR — NOT NULL — message
  • metadata — JSONB — 메타데이터
  • organization_id — VARCHAR — 조직 ID
  • read_at — VARCHAR — read_at
  • title — VARCHAR — NOT NULL — 제목
  • type — VARCHAR — 타입
  • user_id — VARCHAR — 사용자 ID

organization_credits

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • balance — DECIMAL — 잔액
  • created_at — VARCHAR — 생성 시간
  • last_transaction_at — VARCHAR — last_transaction_at
  • organization_id — VARCHAR — 조직 ID
  • total_earned — DECIMAL — total_earned
  • total_spent — DECIMAL — total_spent
  • updated_at — VARCHAR — 수정 시간

organization_members

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • can_create_api_keys — BOOLEAN — can_create_api_keys
  • can_invite_members — BOOLEAN — can_invite_members
  • can_manage_billing — BOOLEAN — can_manage_billing
  • created_at — VARCHAR — 생성 시간
  • invited_by — VARCHAR — invited_by
  • joined_at — VARCHAR — joined_at
  • organization_id — VARCHAR — 조직 ID
  • permissions — JSONB — permissions
  • role — TEXT — role
  • updated_at — VARCHAR — 수정 시간
  • user_id — VARCHAR — 사용자 ID

organizations

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • avatar_url — VARCHAR — avatar_url
  • created_at — VARCHAR — 생성 시간
  • created_by — VARCHAR — 생성자 ID
  • description — VARCHAR — 설명
  • name — VARCHAR — NOT NULL — 이름
  • slug — VARCHAR — NOT NULL — URL 친화적 식별자
  • updated_at — VARCHAR — 수정 시간
  • website_url — VARCHAR — website_url

payment_methods

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • card_brand — VARCHAR — card_brand
  • card_exp_month — DECIMAL — card_exp_month
  • card_exp_year — DECIMAL — card_exp_year
  • card_last4 — VARCHAR — card_last4
  • context_type — TEXT — NOT NULL — context_type
  • created_at — VARCHAR — 생성 시간
  • is_active — BOOLEAN — 활성화 여부
  • is_default — BOOLEAN — is_default
  • organization_id — VARCHAR — 조직 ID
  • stripe_payment_method_id — VARCHAR — NOT NULL — stripe_payment_method_id
  • type — VARCHAR — NOT NULL — 타입
  • updated_at — VARCHAR — 수정 시간
  • user_id — VARCHAR — 사용자 ID

reviews

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • comment — VARCHAR — ARCHAR NULL COMMENT 'comment
  • cons — VARCHAR — cons
  • context — TEXT — NOT NULL — context
  • created_at — VARCHAR — 생성 시간
  • helpful_count — DECIMAL — helpful_count
  • is_public — BOOLEAN — 공개 여부
  • is_verified_purchase — BOOLEAN — is_verified_purchase
  • organization_id — VARCHAR — 조직 ID
  • product_id — VARCHAR — product_id
  • pros — VARCHAR — pros
  • rating — DECIMAL — rating
  • reported_count — DECIMAL — reported_count
  • title — VARCHAR — 제목
  • updated_at — VARCHAR — 수정 시간
  • user_id — VARCHAR — 사용자 ID

sessions

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • admin_id — VARCHAR — admin_id
  • created_at — VARCHAR — 생성 시간
  • device_info — JSONB — device_info
  • ip_address — INET — ip_address
  • is_active — BOOLEAN — 활성화 여부
  • last_activity_at — VARCHAR — last_activity_at
  • session_token — VARCHAR — NOT NULL — session_token
  • user_agent — VARCHAR — user_agent

support_tickets

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • user_id — VARCHAR — 사용자 ID
  • category_id — VARCHAR — category_id
  • organization_id — VARCHAR — 조직 ID
  • product_id — VARCHAR — product_id
  • assigned_to — VARCHAR — assigned_to
  • context_type — TEXT — context_type
  • created_at — VARCHAR — 생성 시간
  • description — VARCHAR — NOT NULL — 설명
  • first_response_at — VARCHAR — first_response_at
  • last_activity_at — VARCHAR — last_activity_at
  • priority — VARCHAR — priority
  • resolution — VARCHAR — resolution
  • resolved_at — VARCHAR — resolved_at
  • satisfaction_rating — DECIMAL — satisfaction_rating
  • status — VARCHAR — 상태
  • tags — VARCHAR — tags
  • ticket_number — VARCHAR — NOT NULL — ticket_number
  • title — VARCHAR — NOT NULL — 제목
  • updated_at — VARCHAR — 수정 시간

usage_logs

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • context_type — TEXT — NOT NULL — context_type
  • created_at — VARCHAR — 생성 시간
  • credits_used — DECIMAL — credits_used
  • error_message — VARCHAR — error_message
  • ip_address — INET — ip_address
  • organization_id — VARCHAR — 조직 ID
  • processing_time_ms — DECIMAL — processing_time_ms
  • product_id — VARCHAR — product_id
  • request_data — JSONB — request_data
  • response_data — JSONB — response_data
  • session_id — VARCHAR — session_id
  • status_code — DECIMAL — status_code
  • user_agent — VARCHAR — user_agent
  • user_id — VARCHAR — 사용자 ID

user_credits

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • balance — DECIMAL — 잔액
  • created_at — VARCHAR — 생성 시간
  • last_transaction_at — VARCHAR — last_transaction_at
  • total_earned — DECIMAL — total_earned
  • total_spent — DECIMAL — total_spent
  • updated_at — VARCHAR — 수정 시간
  • user_id — VARCHAR — 사용자 ID

user_profiles

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • avatar_url — VARCHAR — avatar_url
  • bio — VARCHAR — bio
  • company — VARCHAR — company
  • created_at — VARCHAR — 생성 시간
  • display_name — VARCHAR — display_name
  • email_notifications — BOOLEAN — email_notifications
  • is_active — BOOLEAN — 활성화 여부
  • is_verified — BOOLEAN — is_verified
  • last_login_at — VARCHAR — last_login_at
  • location — VARCHAR — location
  • login_count — DECIMAL — login_count
  • marketing_emails — BOOLEAN — marketing_emails
  • privacy_accepted_at — VARCHAR — privacy_accepted_at
  • role — TEXT — role
  • terms_accepted_at — VARCHAR — terms_accepted_at
  • updated_at — VARCHAR — 수정 시간
  • username — VARCHAR — 사용자명
  • website_url — VARCHAR — website_url

users

  • id — VARCHAR — Primary key — NOT NULL — 고유 식별자
  • aud — VARCHAR — aud
  • banned_until — VARCHAR — banned_until
  • confirmation_sent_at — VARCHAR — confirmation_sent_at
  • confirmation_token — VARCHAR — confirmation_token
  • confirmed_at — VARCHAR — confirmed_at
  • created_at — VARCHAR — 생성 시간
  • deleted_at — VARCHAR — deleted_at
  • email — VARCHAR — 이메일 주소
  • email_change — VARCHAR — email_change
  • email_change_confirm_status — DECIMAL — email_change_confirm_status
  • email_change_sent_at — VARCHAR — email_change_sent_at
  • email_change_token_current — VARCHAR — email_change_token_current
  • email_change_token_new — VARCHAR — email_change_token_new
  • email_confirmed_at — VARCHAR — email_confirmed_at
  • encrypted_password — VARCHAR — encrypted_password
  • instance_id — VARCHAR — instance_id
  • invited_at — VARCHAR — invited_at
  • is_anonymous — BOOLEAN — NOT NULL — is_anonymous
  • is_sso_user — BOOLEAN — NOT NULL — is_sso_user
  • is_super_admin — BOOLEAN — is_super_admin
  • last_sign_in_at — VARCHAR — last_sign_in_at
  • phone — VARCHAR — phone
  • phone_change — VARCHAR — phone_change
  • phone_change_sent_at — VARCHAR — phone_change_sent_at
  • phone_change_token — VARCHAR — phone_change_token
  • phone_confirmed_at — VARCHAR — phone_confirmed_at
  • raw_app_meta_data — JSONB — raw_app_meta_data
  • raw_user_meta_data — JSONB — raw_user_meta_data
  • reauthentication_sent_at — VARCHAR — reauthentication_sent_at
  • reauthentication_token — VARCHAR — reauthentication_token
  • recovery_sent_at — VARCHAR — recovery_sent_at
  • recovery_token — VARCHAR — recovery_token
  • role — VARCHAR — role
  • updated_at — VARCHAR — 수정 시간