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