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)