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 — 수정 시간