헤이 밥 먹어영

테이블 (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