헤이밥먹어영

테이블 (5)

bank_accounts

  • account_id — SERIAL
  • user_id — INT — NOT NULL
  • bank_code — VARCHAR(10)
  • account_no — VARCHAR(30)

join_requests

  • req_id — SERIAL
  • post_id — INT — NOT NULL
  • requester_id — INT — NOT NULL
  • qty_requested — INT

meal_posts

  • post_id — SERIAL
  • user_id — INT — NOT NULL
  • title — VARCHAR(100)
  • price — INT

payments

  • payment_id — SERIAL
  • req_id — INT — NOT NULL
  • from_acc_id — INT — NOT NULL
  • to_acc_id — INT — NOT NULL
  • amount — INT

users

  • user_id — SERIAL
  • name — VARCHAR(50)