prologue

Tables (6)

tb_meeting_categories

  • categorySeq — bigint — Primary key
  • name — varchar(100) — NOT NULL
  • sortOrder — int

tb_meeting_category_map

  • seq (id) — bigint — Primary key
  • categorySeq — bigint — Foreign key → tb_meeting_categories.categorySeq — NOT NULL
  • meetingSeq (meetingSeq2) — bigint — Foreign key → tb_meetings.meetingSeq

tb_meeting_images

  • imageSeq (meetingSeq) — bigint — Primary key — NOT NULL
  • url — varchar(500) — NOT NULL
  • isPrimary — boolean — NOT NULL
  • sortOrder — int
  • meetingSeq (meetingSeq2) — bigint — Foreign key → tb_meetings.meetingSeq

tb_meeting_participants

  • participantSeq — bigint — Primary key
  • meetingSeq — bigint — Foreign key → tb_meetings.meetingSeq — NOT NULL
  • userSeq — bigint — Foreign key → tb_users.userSeq — NOT NULL
  • role — ENUM — NOT NULL
  • createdAt — timestamptz
  • updatedAt — timestamptz

tb_meetings

  • meetingSeq — bigint — Primary key
  • title — varchar(200) — NOT NULL
  • description — text
  • location — varchar(255)
  • lat — numeric(10,7)
  • lng — numeric(10,7)
  • startTime — timestamptz — NOT NULL
  • capacity — int
  • status — ENUM — NOT NULL
  • participantCount — int — NOT NULL
  • ownerSeq — bigint — Foreign key → tb_users.userSeq — NOT NULL
  • createdAt — timestamptz
  • updatedAt — timestamptz

tb_users

  • userSeq — bigint — Primary key
  • email — varchar(255) — NOT NULL
  • password — varchar(255)
  • name — varchar(100)
  • companyName — varchar(100)
  • position — varchar(100)
  • profileImageUrl — varchar(500)
  • createdAt — timestamptz
  • updatedAt — timestamptz