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