헤이 밥 먹어영
테이블 (5)
bank_accounts
- account_id — SERIAL — 기본 키
- user_id — SERIAL — 외래 키 → users.user_id
- bank_code — VARCHAR(10)
- account_no — VARCHAR(30)
- verified — BOOLEAN
- verified_at — TIMESTAMP
join_requests
- post_id — INT — 기본 키 — NOT NULL
- user_id — SERIAL — 외래 키 → users.user_id
- post_id (post_id2) — SERIAL — 외래 키 → meal_posts.post_id
- user_id (user_id2) — SERIAL — 외래 키 → meal_posts.user_id
- req_id — SERIAL
- requester_id — INT — NOT NULL
- qty_requested — INT
- status — VARCHAR(10)
- created_at — TIMESTAMP
meal_posts
- post_id — SERIAL — 기본 키
- user_id (user_id2) — SERIAL — 외래 키 → users.user_id
- user_id — INT — NOT NULL
- title — VARCHAR(100)
- description — TEXT
- price — INT
- total_qty — INT
- remain_qty — INT
- status — VARCHAR(10)
- created_at — TIMESTAMP
- expire_at — TIMESTAMP
payments
- payment_id — SERIAL — 기본 키
- post_id — INT — 외래 키 → join_requests.post_id — NOT NULL
- user_id — SERIAL — 외래 키 → join_requests.user_id
- post_id (post_id2) — SERIAL — 외래 키 → join_requests.post_id
- user_id (user_id2) — SERIAL — 외래 키 → join_requests.user_id
- account_id — SERIAL — 외래 키 → bank_accounts.account_id
- user_id (user_id3) — SERIAL — 외래 키 → bank_accounts.user_id
- req_id — INT — NOT NULL
- from_acc_id — INT — NOT NULL
- to_acc_id — INT — NOT NULL
- amount — INT
- fee — INT
- status — VARCHAR(10)
- requested_at — TIMESTAMP
- completed_at — TIMESTAMP
users
- user_id — SERIAL — 기본 키
- name — VARCHAR(50) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- profile_pic — VARCHAR(255)
- created_at — TIMESTAMP
- last_login — TIMESTAMP