allimjang_real
Tables (22)
boards
- id — BIGSERIAL
- organization_id — BIGINT — Foreign key → organizations.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- visibility — board_visibility — NOT NULL
- created_at — TIMESTAMP — NOT NULL
chat_members
- room_id — BIGINT — Primary key — Foreign key → chat_rooms.id — NOT NULL
- user_id — BIGINT — Primary key — Foreign key → users.id — NOT NULL
- role_in_room — chat_room_role — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
chat_messages
- id — BIGSERIAL
- room_id — BIGINT — Foreign key → chat_rooms.id — NOT NULL
- sender_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
chat_reads
- message_id — BIGINT — Primary key — Foreign key → chat_messages.id — NOT NULL
- user_id — BIGINT — Primary key — Foreign key → users.id — NOT NULL
- read_at — TIMESTAMP — NOT NULL
chat_rooms
- id — BIGSERIAL
- organization_id — BIGINT — Foreign key → organizations.id — NOT NULL
- created_by — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(100)
- created_at — TIMESTAMP — NOT NULL
group_members
- group_id — BIGINT — Primary key — Foreign key → groups.id — NOT NULL
- user_id — BIGINT — Primary key — Foreign key → users.id — NOT NULL
- role_in_group — group_member_role — NOT NULL
- joined_at — TIMESTAMP — NOT NULL
groups
- id — BIGSERIAL
- organization_id — BIGINT — Foreign key → organizations.id — NOT NULL
- name — VARCHAR(100) — NOT NULL
- grade — INTEGER
- class_no — INTEGER
- year — INTEGER
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
notice_attachments
- id — BIGSERIAL
- notice_id — BIGINT — Foreign key → notices.id — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- file_url — VARCHAR(500) — NOT NULL
- file_size — BIGINT — NOT NULL
- uploaded_at — TIMESTAMP — NOT NULL
notice_reads
- notice_id — BIGINT — Primary key — Foreign key → notices.id — NOT NULL
- user_id — BIGINT — Primary key — Foreign key → users.id — NOT NULL
- read_at — TIMESTAMP — NOT NULL
notice_targets
- id — BIGSERIAL
- notice_id — BIGINT — Foreign key → notices.id — NOT NULL
- target_type — target_type — NOT NULL
- group_id — BIGINT — Foreign key → groups.id
- grade — INTEGER
- class_no — INTEGER
- user_id — BIGINT — Foreign key → users.id
notices
- id — BIGSERIAL
- organization_id — BIGINT — Foreign key → organizations.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- type — notice_type — NOT NULL
- priority — notice_priority — NOT NULL
- title — VARCHAR(200) — NOT NULL
- content — TEXT — NOT NULL
- pinned — BOOLEAN — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
organizations
- id — BIGSERIAL
- name — VARCHAR(200) — NOT NULL
- type — organization_type — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
post_comments
- id — BIGSERIAL
- post_id — BIGINT — Foreign key → posts.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- content — TEXT — NOT NULL
- created_at — TIMESTAMP — NOT NULL
posts
- id — BIGSERIAL
- 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
student_parents
- student_id — BIGINT — Primary key — Foreign key → users.id — NOT NULL
- parent_id — BIGINT — Primary key — Foreign key → users.id — NOT NULL
- relation_type — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
survey_answers
- id — BIGSERIAL
- response_id — BIGINT — Foreign key → survey_responses.id — NOT NULL
- question_id — BIGINT — Foreign key → survey_questions.id — NOT NULL
- choice_id — BIGINT — Foreign key → survey_choices.id
- text_answer — TEXT
survey_choices
- id — BIGSERIAL
- question_id — BIGINT — Foreign key → survey_questions.id — NOT NULL
- text — VARCHAR(200) — NOT NULL
- order_no — INTEGER — NOT NULL
survey_questions
- id — BIGSERIAL
- survey_id — BIGINT — Foreign key → surveys.id — NOT NULL
- type — question_type — NOT NULL
- text — TEXT — NOT NULL
- required — BOOLEAN — NOT NULL
- order_no — INTEGER — NOT NULL
- created_at — TIMESTAMP — NOT NULL
survey_responses
- id — BIGSERIAL
- survey_id — BIGINT — Foreign key → surveys.id — NOT NULL
- respondent_id — BIGINT — Foreign key → users.id — NOT NULL
- submitted_at — TIMESTAMP — NOT NULL
surveys
- id — BIGSERIAL
- organization_id — BIGINT — Foreign key → organizations.id — NOT NULL
- author_id — BIGINT — Foreign key → users.id — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- start_at — TIMESTAMP
- end_at — TIMESTAMP
- status — survey_status — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP
user_roles
- user_id — BIGINT — Primary key — Foreign key → users.id — NOT NULL
- role — user_role — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
users
- id — BIGSERIAL
- organization_id — BIGINT — Foreign key → organizations.id — NOT NULL
- email — VARCHAR(100) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- name — VARCHAR(50) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP