triply

Tables (12)

ExchangeRate

    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