hanati
Tables (5)
account (계좌)
- acoount_num (계좌번호) — Primary key — NOT NULL
- id (아이디) — Foreign key → member.id — NOT NULL
- balance (계좌잔액)
deposit (적금 납입 내역)
- account_num (계좌번호) — Primary key — NOT NULL
- deposit_date (납입날짜)
- deposit_amount (납입액)
- id (그룹아이디) — Foreign key → group.id — NOT NULL
group (그룹)
- id (그룹아이디) — Primary key — NOT NULL
- name (그룹명)
- chief (그룹장아이디) — Foreign key → member.id — NOT NULL
- goal_balance (목표금액)
- goal_num (목표납입횟수)
- start_date (시작일)
- end_date (종료일)
- country (나라)
- city (도시)
- success (성공여부)
- age (설정나이)
group_account (그룹계좌)
- account_num (계좌번호) — Primary key — NOT NULL
- id (아이디)
- balance (납입액)
- group_id (그룹아이디) — Foreign key → group.id — NOT NULL
member (회원)
- id (아이디) — Primary key — NOT NULL
- name (성명)
- sex (성별)
- age (나이)
- password (패쓰워드)
- photo (사진경로)
- phone (핸드폰번호)