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