triply
Tables (12)
Group
- group_id — integer — Primary key — NOT NULL
- group_title
- user_id — Foreign key → User.user_id — NOT NULL — 그룹만든 회원 id owner
- createdAt
GroupInvitation
- invitation_id — Primary key — NOT NULL
- user_id (sender_id) — Foreign key → User.user_id — NOT NULL — 회원 기본키
- user_id (receiver_id) — Foreign key → User.user_id — NOT NULL — 회원 기본키
- group_id — integer — Foreign key → Group.group_id — NOT NULL
- status — PENDING, ACCEPTED, REJECTED
GroupMember
- member_id — Primary key — NOT NULL
- group_id — integer — Foreign key → Group.group_id — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 회원 기본키
- role
Notification
- notification_id — Primary key — NOT NULL
- user_id (sender_id) — Foreign key → User.user_id — NOT NULL — 알림 보낸 사람(그룹초대나 정산)
- type — GROUP_INVITE / SETTLEMENT_REQUEST / SETTLEMENT_COMPLETE(이건고민)
- content — 타입에 따라 제목지정, 내용은 여기
- is_read
- created_at
- receiver_id — Foreign key → User.user_id — NOT NULL — 알람 받는사람
- target_id
Payment
- payment_id — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 회원 기본키
- trip_id — integer — Foreign key → Trip.trip_id — NOT NULL
- merchant_name — 가맹점이름
- amount
- currency — 통화
- payment_at
Settlement
- settlement_id — Primary key — NOT NULL
- payment_id — Foreign key → Payment.payment_id — NOT NULL
- user_id (from_user_id) — Foreign key → User.user_id — NOT NULL — 회원 기본키
- user_id (to_user_id) — Foreign key → User.user_id — NOT NULL — 회원 기본키
- amount
- status
- requested_at
- completed_at
Trip
- trip_id — integer — Primary key — NOT NULL
- trip_title — text — 여행의 제목, 공백 가능 없으면 걍 지역명 ㄱㄱ
- trip_place — NOT NULL
- start_date — NOT NULL
- end_date — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 그룹을 생성한 회원 기본키
- group_id — integer — Foreign key → Group.group_id — NOT NULL — null이면 userid만, null이 아니면 group_id만 보도록해야할듯? 아니면
- trip_img
TripSchedule
- schedule_id — Primary key — NOT NULL
- trip_id — integer — Foreign key → Trip.trip_id — NOT NULL
- schedule_title
- schedule_place
- start_time
- end_time
- schedule_detail
- category
User
- user_id — Primary key — NOT NULL — 회원 기본키
- login_id — text — 로그인 아이디, 중복x
- login_pw — text — 로그인 비밀번호, 암호화 된 상태로 저장
- user_name (username) — text — 회원이름
- user_phone — text — 회원번호 11자리
- user_img
Wallet
- wallet_id — Primary key — NOT NULL
- user_id — Foreign key → User.user_id — NOT NULL — 회원 기본키
- balance
- updated_at — 고민
WalletTransaction
- transaction_id — Primary key — NOT NULL
- settlement_id — Foreign key → Settlement.settlement_id — NOT NULL
- payment_id — Foreign key → Payment.payment_id — NOT NULL
- type — CHARGE / PAYMENT / SETTLEMENT_IN / SETTLEMENT_OUT
- amount
- transaction_at
- wallet_id — Foreign key → Wallet.wallet_id — NOT NULL
- balance_after