모여락

테이블 (10)

bank_accounts

  • account_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • bank_name — VARCHAR(30) — NOT NULL
  • account_no — VARCHAR(50) — NOT NULL
  • holder_name — VARCHAR(30) — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL

clubs (동아리)

  • club_id — BIGINT — 기본 키 — NOT NULL
  • owner_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • type — club_type — NOT NULL
  • category — VARCHAR(30) — NOT NULL
  • region — VARCHAR(50)
  • intro — TEXT
  • fee_amount — INTEGER — NOT NULL
  • fee_cycle — fee_cycle — NOT NULL
  • recruit_status — recruit_status — NOT NULL
  • current_generation — INTEGER
  • is_public — BOOLEAN — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

events

  • event_id — BIGINT — 기본 키 — NOT NULL
  • club_id — BIGINT — 외래 키 → clubs.club_id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • start_at — TIMESTAMPTZ — NOT NULL
  • location — VARCHAR(100)
  • capacity — INTEGER
  • created_at — TIMESTAMPTZ — NOT NULL

memberships

  • membership_id — BIGINT — 기본 키 — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • club_id — BIGINT — 외래 키 → clubs.club_id — NOT NULL
  • role — membership_role — NOT NULL
  • generation — INTEGER
  • status — membership_status — NOT NULL
  • joined_at — TIMESTAMPTZ — NOT NULL

notice_reads

  • notice_read_id — BIGINT — 기본 키 — NOT NULL
  • notice_id — BIGINT — 외래 키 → notices.notice_id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • read_at — TIMESTAMPTZ — NOT NULL

notices

  • notice_id — BIGINT — 기본 키 — NOT NULL
  • club_id — BIGINT — 외래 키 → clubs.club_id — NOT NULL
  • author_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • event_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

posts

  • post_id — BIGINT — 기본 키 — NOT NULL
  • author_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • club_id — BIGINT — 외래 키 → clubs.club_id
  • board_type — board_type — NOT NULL
  • category — VARCHAR(30)
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT — NOT NULL
  • view_count — INTEGER — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ

settlement_payments

  • payment_id — BIGINT — 기본 키 — NOT NULL
  • settlement_id — BIGINT — 외래 키 → settlements.settlement_id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL
  • status — payment_status — NOT NULL
  • paid_at — TIMESTAMPTZ

settlements (정산)

  • settlement_id — BIGINT — 기본 키 — NOT NULL
  • club_id — BIGINT — 외래 키 → clubs.club_id — NOT NULL
  • account_id — BIGINT — 외래 키 → bank_accounts.account_id
  • title — VARCHAR(100) — NOT NULL
  • amount — INTEGER — NOT NULL
  • due_date — DATE
  • status — settlement_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL

users (사용자)

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(30) — NOT NULL
  • university — VARCHAR(100)
  • is_student_verified — BOOLEAN — NOT NULL
  • status — user_status — NOT NULL
  • created_at — TIMESTAMPTZ — NOT NULL
  • updated_at — TIMESTAMPTZ — NOT NULL
  • deleted_at — TIMESTAMPTZ