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