allimjang
Tables (19)
boards
- id — BIGSERIAL
- org_id — BIGINT — Foreign key → organizations.id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- visibility — VARCHAR(20) — NOT NULL
- ROLE)) — CREATE
- board_id — BIGINT — Foreign key → boards.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
chat_members
- room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- role_in_room — VARCHAR(20) — NOT NULL
chat_messages
- id — BIGSERIAL
- sender_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
chat_reads
- message_id — BIGINT — Foreign key → chat_messages.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- read_at — TIMESTAMP — NOT NULL
chat_rooms
- id — BIGSERIAL
- org_id — BIGINT — Foreign key → organizations.id — NOT NULL
- title — VARCHAR(200)
- created_at — TIMESTAMP — NOT NULL
group_members
- group_id — BIGINT — Foreign key → groups.id — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- role_in_group — VARCHAR(20) — NOT NULL
groups
- id — BIGSERIAL
- organization_id — BIGINT — Foreign key → organizations.id — NOT NULL
- name — VARCHAR(200) — NOT NULL
- class_no — INT
- year — INT
- created_at — TIMESTAMP — NOT NULL
notice_reads
- notice_id — BIGINT — Foreign key → notices.id — NOT NULL
- read_at — TIMESTAMP — NOT NULL
notice_targets
- id — BIGSERIAL
- notice_id — BIGINT — Foreign key → notices.id — NOT NULL
- target_type — VARCHAR(20) — NOT NULL
- group_id — BIGINT — Foreign key → groups.id
- class_no — INT
- user_id — BIGINT — Foreign key → users.id
notices
- id — BIGSERIAL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- pinned — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
organizations
- id — BIGSERIAL
- name — VARCHAR(200) — NOT NULL
- type — VARCHAR(20) — NOT NULL
post_comments
- id — BIGSERIAL
- post_id — BIGINT — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
student_parent
- student_id — BIGINT — Foreign key → users.id — NOT NULL
- parent_id — BIGINT — Foreign key → users.id — NOT NULL
- relation_type — VARCHAR(20) — NOT NULL
survey_answers
- id — BIGSERIAL
- response_id — BIGINT — NOT NULL
- question_id — BIGINT — NOT NULL
- choice_id — BIGINT — Foreign key → survey_choices.id
- text_answer — TEXT
survey_choices
- id — BIGSERIAL
- question_id — BIGINT — NOT NULL
- text — VARCHAR(200) — NOT NULL
survey_questions
- survey_id — BIGINT — Foreign key → surveys.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- text — TEXT — NOT NULL
surveys
- id — BIGSERIAL
- org_id — BIGINT — Foreign key → organizations.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- start_at — TIMESTAMP — NOT NULL
- end_at — TIMESTAMP — NOT NULL
- status — VARCHAR(20) — NOT NULL
user_roles
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- role — user_role — NOT NULL
users
- id — BIGSERIAL
- org_id — BIGINT — Foreign key → organizations.id — NOT NULL
- email — VARCHAR(200) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- updated_at — TIMESTAMP — NOT NULL