getdon

Tables (9)

automatic_payment

  • automatic_payment_id — int — Primary key — NOT NULL — 자동이체 id
  • meeting_member_id — int — Foreign key → meeting_member.meeting_member_id — NOT NULL — 모임 멤버 id
  • payment_amount — int — NOT NULL — 금액
  • payment_day — int — NOT NULL — 이체일
  • active_yn — varchar(1) — NOT NULL — 활성화 여부
  • create_dt — datetime — NOT NULL — 생성일
  • update_dt — datetime — 수정일

deposit

  • deposit_id — int — Primary key — NOT NULL — 입금 id
  • meeting_member_id — int — Foreign key → meeting_member.meeting_member_id — NOT NULL — 모임 멤버 id
  • deposit_amount — int — NOT NULL — 입금액
  • create_dt — datetime — NOT NULL — 생성일

meeting

  • meeting_id — int — Primary key — NOT NULL — 모임 id
  • user_id — int — Foreign key → users.user_id — NOT NULL — 유저 id
  • title — varchar(50) — NOT NULL — 모임 제목
  • bank_name — varchar(20) — NOT NULL — 은행명
  • bank_account — int — NOT NULL — 은행 계좌
  • amount — int — NOT NULL — 통장 잔액
  • delete_yn — varchar(1) — NOT NULL — 삭제 여부
  • create_dt — datetime — NOT NULL — 생성일
  • update_dt — datetime — 수정일

meeting_member

  • meeting_member_id — int — Primary key — NOT NULL — 모임 멤버 id
  • user_id — int — Foreign key → users.user_id — NOT NULL — 유저 id
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL — 모임 id
  • role — varchar(10) — NOT NULL — 권한 (leader, member)
  • withdrawal_yn — varchar(1) — NOT NULL — 탈퇴 YN
  • create_dt — datetime — NOT NULL — 생성일
  • update_dt — datetime — 수정일

one_time_payment

  • one_time_payment_id — int — Primary key — NOT NULL — 1회성 회비 id
  • meeting_id — int — Foreign key → meeting.meeting_id — NOT NULL — 모임 id
  • meeting_member_id — int — Foreign key → meeting_member.meeting_member_id — NOT NULL — 모임 멤버 id
  • amount — int — NOT NULL — 금액
  • deadline — date — NOT NULL — 마감일
  • create_dt — datetime — NOT NULL — 생성일
  • update_dt — datetime — 수정일

one_time_payment_member

  • one_time_payment_member_id — int — Primary key — NOT NULL — 1회성 회비 멤버 id
  • one_time_payment_id — int — Foreign key → one_time_payment.one_time_payment_id — NOT NULL — 1회성 회비 id
  • meeting_member_id — int — Foreign key → meeting_member.meeting_member_id — NOT NULL — 모임 멤버 id
  • create_dt — datetime — NOT NULL — 생성일
  • update_dt — datetime — 수정일

payment_history

  • payment_history_id — int — Primary key — NOT NULL — 이체 이력 id
  • meeting_member_id — int — Foreign key → meeting_member.meeting_member_id — NOT NULL — 모임 멤버 id
  • automatic_payment_id — int — Foreign key → automatic_payment.automatic_payment_id — 자동이체 id
  • one_time_fee_member_id — int — 1회성 회비 멤버 id
  • amount — int — NOT NULL — 납부 금액
  • payment_status — varchar(10) — 상태 (success/fail/pending, exemption)
  • create_dt — datetime — NOT NULL — 생성일
  • update_dt — datetime — 수정일

users

  • user_id — int — Primary key — NOT NULL — 유저 id
  • user_name — varchar(10) — NOT NULL — 유저 이름
  • profile_url — varchar(300) — 프로필 URL
  • email — varchar(30) — NOT NULL — 유저 이메일
  • password — varchar(255) — NOT NULL — 유저 패스워드
  • provider — varchar(10) — NOT NULL — oauth (NORMAL, GOOGLE, KAKAO)
  • provider_id — varchar(255) — oauth_id
  • use_yn — varchar(1) — NOT NULL — 사용 여부
  • create_dt — datetime — NOT NULL — 생성일
  • update_dt — datetime — 수정일

withdrawal

  • withdrawal_id — int — Primary key — NOT NULL — 출금 id
  • meeting_member_id — int — Foreign key → meeting_member.meeting_member_id — NOT NULL — 모임 멤버 id
  • withdrawal_amount — int — NOT NULL — 출금액
  • create_dt — datetime — NOT NULL — 생성일