zogakzip_team1

Tables (5)

badge (뱃지)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • description (Field2)
  • Field3 — datetime

comment (댓글)

  • id (Key) — int — Primary key — NOT NULL
  • post_id (Key2) — int — Foreign key → post.id — NOT NULL
  • nickname (Field4) — varchar
  • content (Field) — varchar
  • createdAt (Field2) — datetime
  • password (Field3)

group (그룹)

  • id (Key) — int — Primary key — NOT NULL
  • name (Field) — varchar
  • imageUrl (Field2) — varchar
  • isPublic (Field3) — boolean
  • likeCount (Field4) — int
  • postCount (Field6) — int
  • createdAt (Field7) — datetime — NOT NULL
  • introduction (Field8) — varchar
  • password (Field5)

group_badge (Untitled)

  • groupid (Key) — int — Foreign key → badge.id — NOT NULL
  • badgeid (Key2) — int — Foreign key → group.id — NOT NULL
  • createdAt (Field) — datetime

post (추억)

  • id (Key) — int — Primary key — NOT NULL
  • group_id (Key2) — int — Foreign key → group.id — NOT NULL
  • nickname (Field11) — varchar
  • title (Field) — varchar
  • content (Field2) — varchar
  • imageUrl (Field3) — varchar
  • location (Field4) — varchar
  • moment (Field5) — datetime
  • isPublic (Field6) — boolean
  • likeCount (Field7) — int
  • commentCount (Field8) — int
  • createdAt (Field9) — datetime
  • password (Field10)