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 — 생성일