ToGather

Tables (7)

chat_room_group

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → group_buy.Key — NOT NULL
  • Key (Key3) — Foreign key → users.Key — NOT NULL

comment (댓글)

  • Key — Primary key — NOT NULL
  • title (Field)
  • content (Field4)
  • Key (Key2) — Foreign key → community.Key — NOT NULL
  • Key (Key3) — Foreign key → users.Key — NOT NULL

community (커뮤니티 기능)

  • Key — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • photo (Field3)
  • created_at (Field4)
  • like (Field5)
  • Key (Key2) — Foreign key → users.Key — NOT NULL

group_buy (공동구매 컨텐츠)

  • Key — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • view (Field3)
  • like (Field5)
  • headCount (Field4)
  • created_at (Field6)
  • photo (Field7)
  • latitue (Field8)
  • longtitue (Field9)
  • currentCount (Field10)
  • Key (Key2) — Foreign key → users.Key — NOT NULL

massage (채팅메시지)

  • Key — Primary key — NOT NULL
  • content (Field)
  • is_readed (Field2)
  • created_at (Field3)
  • Key (Key2) — Foreign key → users.Key — NOT NULL
  • Key (Key3) — Foreign key → chat_room_group.Key — NOT NULL

users (Untitled)

  • Key — Primary key — NOT NULL
  • name (Field3)
  • phone (Field5)
  • photo (Field)

waiting (교환대기, 공동구매 대기)

  • Key — Primary key — NOT NULL
  • Key (Key3) — Foreign key → group_buy.Key — NOT NULL
  • Key (Key2) — Foreign key → users.Key — NOT NULL