DobDob-ERD
Tables (9)
Comment (Untitled4)
- commentId (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- postId (Key3) — Long — Foreign key → Post.postId — NOT NULL
- content (Field) — String
- isDeleted (Field4) — Boolean
- createdAt (Field2) — DATETIME
Like (Untitled8)
- likeId (Key) — Long — Primary key — NOT NULL
- postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
- userId (Key22) — Long — Foreign key → Post.userId — NOT NULL
Location (Untitled3)
- locationId (Key) — Long — Primary key — NOT NULL
- si (Field) — String
- gu (Field2) — String
- dong (Field3) — String
- locationX (Field4) — Float
- locationY (Field5) — Float
Post (Untitled2)
- postId (Key) — Long — Primary key — NOT NULL
- userId (Key2) — Long — Foreign key → User.userId — NOT NULL
- locationId (Key3) — Long — Foreign key → Location.locationId — NOT NULL
- title (Field) — String
- content (Field2) — TEXT
- isDeleted (Field6) — Boolean
- createdAt (Field3) — DATETIME
- editedAt (Field4) — DATETIME
PostImage (Untitled7)
- postImageId (Key) — Long — Primary key — NOT NULL
- postId (Key2) — Long — Foreign key → Post.postId — NOT NULL
- url (Field) — String
PostTag (Untitled6)
- postId (Key) — Long — Foreign key → Post.postId — NOT NULL
- tagId (Key4) — Long — Foreign key → Tag.tagId — NOT NULL
Tag (Untitled5)
- tagId (Key) — Long — Primary key — NOT NULL
- name (Field) — String
User (Untitled)
- userId (Key) — Long — Primary key — NOT NULL
- locationId (Key2) — Long — Foreign key → Location.locationId — NOT NULL
- email (Field) — String
- socialType (Field2) — String
- nickName (Field3) — String
- profileUrl (Field4) — String
- accessToken (Field5) — String
- refreshToken (Field6) — String