projecthub

Tables (10)

Account (계좌)

  • id (계좌아이디) — Primary key — NOT NULL
  • user_id (회원아이디) — Foreign key → User.id — NOT NULL
  • account_number (계좌번호)
  • balance (금액)
  • account_type (계좌유형(메인,적금))

DailyLimit (일일 한도)

  • id (일일한도 아이디) — Primary key — NOT NULL
  • user_id (회원아이디) — Foreign key → User.id — NOT NULL
  • remaining_limit (남은 일일한도)
  • date (해당 일자)

Metadata (FileMetadata)

  • meta_id (기본키) — INT — Primary key — NOT NULL
  • meta_capacity (파일데이터 용량) — DOUBLE
  • meta_name (메타데이터 이름) — VARCHAR
  • stored_name (파일데이터 이름) — VARCHAR
  • upload_time (업로드시간) — DATE
  • userId (업로드한사람) — VARCHAR

Savings-product (저축상품)

  • id (저축상품아이디) — Primary key — NOT NULL
  • name (저축상품이름)
  • interest_rate (이자율)
  • type (저축상품유형)

Settlement (정산)

  • id (정산아이디) — Primary key — NOT NULL
  • total_amount (정산금액)
  • type (정산유형)
  • status (정산상태)
  • created_at (정산생성일시)
  • updated_at (정산정보최종수정일시)

Settlement_Participant (정산참여자)

  • id (정산참여아이디) — Primary key — NOT NULL
  • user_id (고유값) — Foreign key → User.id — NOT NULL
  • settle_id (정산아이디) — Foreign key → Settlement.id — NOT NULL
  • amount (참여자별 정산금액)
  • ispaid (정산완료여부)

Transaction (거래)

  • id (거래아이디) — Primary key — NOT NULL
  • from_account_id (출금계좌) — Foreign key → Account.id — NOT NULL
  • to_account_id (입금계좌) — Foreign key → Account.user_id — NOT NULL
  • amount (거래금액)
  • status (거래상태)
  • description (거래설명)
  • created_at (거래생성일시)
  • updated_at (거래정보최종수정일시)

Transaction_Log (Untitled2)

  • id (로그기록아이디) — Primary key — NOT NULL
  • transaction_id (거래아이디) — Foreign key → Transaction.id — NOT NULL
  • description (로그설명)
  • created_at (로그생성일시)

User (Untitled)

  • id (고유값) — Primary key — NOT NULL
  • username (회원이름)

folders (CopyOfFileMetadata)

  • folder_id (기본키) — INT — Primary key — NOT NULL
  • folder_name (파일데이터 용량) — DOUBLE
  • folder_path (메타데이터 이름) — VARCHAR
  • userId (파일데이터 이름) — VARCHAR
  • createdAt (업로드시간) — DATE
  • updatedAt (업로드한사람) — VARCHAR