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