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