receipt
Tables (16)
account_guidelines (가이드라인 마스터)
- account_guidelines_id (Key) — Primary key — NOT NULL
- provider_name (Field)
- title (Field2)
- file_name (Field3)
budget_item (적요)
- budget_item_id (Key) — Primary key — NOT NULL
- source_type (Field)
- budget_name (Field2)
- notes (Field3)
- pdf_file_name (Field4)
- prompting_text (Field5)
- submit_of_data (Field6)
- team_id (Key2) — Foreign key → team.team_id — NOT NULL
m_user (사용자)
- user_id (Key) — Primary key — NOT NULL
- account_number (Field)
- authority (Field2)
- contact_number (Field3)
- email (Field4)
- nickname (Field5)
- password (Field6)
- role (Field7)
provider_budget_item (CopyOf적요)
- provider_budget_item_id (Key) — Primary key — NOT NULL
- budget_name (Field2)
- notes (Field3)
- pdf_file_name (Field4)
- prompting_text (Field5)
- submit_of_data (Field6)
- account_guidelines_id (Key2) — Foreign key → account_guidelines.account_guidelines_id — NOT NULL
receipt (영수증)
- receipt_id (Key) — Primary key — NOT NULL
- is_finalized (Field)
- total_amount (Field2)
- team_business_name (Field3)
- image_url (Field4)
- payment_details (Field5)
- receipt_memo (Field6)
- team_budget_item_id (Key2) — Foreign key → team_budget_item.team_budget_item_id — NOT NULL
- team_id (Key3) — Foreign key → team.team_id — NOT NULL
- user_id (Key4) — Foreign key → m_user.user_id — NOT NULL
receipt_feedback ((오류 로그)테이블 추가)
- feedback_id (Key) — Primary key — NOT NULL
- receipt_id (Field)
- user_id (Field2)
- issue_type (Field3)
- user_commnet (Field4)
- is_resolved (Field5)
receipt_management (Untitled)
- receipt_management_id (Key) — Primary key — NOT NULL
- is_approved (Field)
- is_transgerred (Field2)
- receipt_id (Key2) — Foreign key → receipt.receipt_id — NOT NULL
receipt_submission (영수증 제출)
- submission_id (Key) — Primary key — NOT NULL
- created_at (Field)
- status (Field2)
- category (Field3)
- file_key (Field4)
- file_name (Field5)
- receipt_id (Key2) — Foreign key → receipt.receipt_id — NOT NULL
subscription (현재 구독중인 메인 상품 정보)
- subscription_id (Key) — Primary key — NOT NULL
- billing_status (Field)
- next_billint_date (Field2)
- customer_uid (Field3)
- team_id (Key2) — Foreign key → team.team_id — NOT NULL
- total_monthly_fee (Field4)
- plan_id (Key3) — Foreign key → subscription_plan.plan_id — NOT NULL
subscription_item (결제 상세 내역 - 선택 사항)
- item_id (Key) — Primary key — NOT NULL
- item_type (Field)
- amount (Field2)
- description (Field3)
subscription_plan (구독상품 마스터)
- plan_id (Key) — Primary key — NOT NULL
- plan_name (Field)
- price (Field2)
- default_gemini_limit (Field3)
- default_storage_gb (Field4)
team (팀)
- team_id (Key) — Primary key — NOT NULL
- team_name (Field)
- team_password (Field2)
team_budget_item (팀_적요_아이템)
- team_budget_item_id (Key) — Primary key — NOT NULL
- price (Field)
- team_id (Key3) — Foreign key → team.team_id — NOT NULL
- budget_item_id (Key2) — Foreign key → budget_item.budget_item_id — NOT NULL
team_usage_limit (팀별 실시간 권한)
- team_usage_limit_id (Key) — Primary key — NOT NULL
- max_storage_gb (Field)
- current_storage_usage_bytes (Field2)
- max_gemini_limit (Field3)
- current_gemini_usage (Field4)
- team_id (Key2) — Foreign key → team.team_id — NOT NULL
- daily_usage_count (Field5)
usage_log (사용 로그 테이블)
- log_id (Key) — Primary key — NOT NULL
- action_type (Field)
- created_at (Field2)
user_team (사용자_팀)
- user_team_id (Key) — Primary key — NOT NULL
- joined_at (Field2)
- role (Field7)
- team_id (Key2) — Foreign key → team.team_id — NOT NULL
- user_id (Key3) — Foreign key → m_user.user_id — NOT NULL