connecting space
Tables (8)
board (게시글)
- board_id (Key) — Long — Primary key — NOT NULL
- event_id (Key2) — Long — Foreign key → event.event_id — NOT NULL
- booth_id (Key3) — Long — Foreign key → booth.booth_id — NOT NULL
- event_id (Key22) — Long — Foreign key → booth.event_id — NOT NULL
- member_id (Key4) — Long — Foreign key → member.member_id — NOT NULL
- mongo_id (Field) — String
- tag (Field2) — String
booth (부스)
- booth_id (Key) — Long — Primary key — NOT NULL
- event_id (Key2) — Long — Foreign key → event.event_id — NOT NULL
- name (Field) — String
- category (Field2) — String
- visitorsCount (Field3) — Integer
- likesCount (Field4) — Integer
- commentsCount (Field8) — Integer
- rating (Field5) — BigDecimal
- links (Field7) — List<String>
- photos (Field6) — MediaType
booth_role (부스 권한 관리)
- (booth_id, member_id) (Key3) — Primary key — NOT NULL
- booth_id (Key2) — Long — Foreign key → booth.booth_id — NOT NULL
- member_id (Key) — Long — Foreign key → member.member_id — NOT NULL
- Role (Field) — ENUM
comment (댓글)
- comment_id (Key) — Long — Primary key — NOT NULL
- booth_id (Key2) — Long — Foreign key → booth.booth_id — NOT NULL
- likeCount (Field2) — Integer
- replyCount (Field3) — Integer
event (행사)
- event_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- place (Field2) — String
- description (Field8) — String
- time (Field7) — Datetime
- Status (Field3) — ENUM
- visitorsCount (Field4) — Integer
- commentsCount (Field5) — Integer
- hasMap (Field6) — Boolean
event_role (이벤트 권한 관리)
- (member_id, event_id) (Key) — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- event_id (Key3) — Long — Foreign key → event.event_id — NOT NULL
- Role (Field) — ENUM
likes (좋아요)
- likes_id (Key) — Long — Primary key — NOT NULL
- member_id (Key2) — Long — Foreign key → member.member_id — NOT NULL
- target_id (Field) — Long
- type (Field2) — ENUM
member (사용자)
- member_id (Key) — Long — Primary key — NOT NULL
- name (Field) — String
- email (Field2) — String
- password (Field3) — String
- booth_id (Field5) — Long
- address (Field6) — String
- birthday (Field4) — String