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