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 (핸드폰번호)