TAB DB ERD

Tables (10)

AccessLog

  • LogId — INT UNSIGNED — Primary key — NOT NULL
  • userId — INT UNSIGNED — Foreign key → User.userId — NOT NULL
  • action (Field) — BLOB

File (Untitled2)

  • fileId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • postId (Key2) — INT UNSIGNED — Foreign key → Post.postId — NOT NULL
  • fileName (Field2) — BLOB
  • fileUrl (Field3) — VARCHAR
  • createdAt (Field4) — DATETIME

Hashtag (Untitled4)

  • hashtagId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • hashtagName (Field) — BLOB

HashtagMap (Untitled7)

  • hashtagMapId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • hashtagId (Key2) — INT UNSIGNED — Foreign key → Hashtag.hashtagId — NOT NULL
  • replyId (Key3) — INT UNSIGNED — Foreign key → Reply.replyId — NOT NULL
  • postId (Key4) — INT UNSIGNED — Foreign key → Post.postId — NOT NULL

Post (Untitled)

  • postId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • userId — INT UNSIGNED — Foreign key → User.userId — NOT NULL
  • title (Field2) — VARCHAR(200)
  • contents (Field3) — BLOB
  • createdAt (Field4) — DATETIME
  • updatedAt (Field5) — DATETIME
  • updatedAt (Field6) — DATETIME

PostLink (Untitled8)

  • postLinkId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • masterPostId(FK) (Key2) — INT UNSIGNED — Foreign key → Post.postId — NOT NULL
  • slavePostId(FK) (Key3) — INT UNSIGNED — Foreign key → Post.postId — NOT NULL

Reply (Untitled3)

  • replyId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • userId — INT UNSIGNED — Foreign key → User.userId — NOT NULL
  • postId (Key2) — INT UNSIGNED — Foreign key → Post.postId — NOT NULL

SearchGroup (Untitled5)

  • searchGroupId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • userId — INT UNSIGNED — Foreign key → User.userId — NOT NULL
  • searchGroupName (Field2) — BLOB
  • orderBy (Field3) — BOOLEAN

SearchGroupCondition (Untitled6)

  • searchGroupConditionId (Key) — INT UNSIGNED — Primary key — NOT NULL
  • searchGroupId (Key2) — INT UNSIGNED — Foreign key → SearchGroup.searchGroupId — NOT NULL
  • andOr (Field2) — BOOLEAN
  • startDate (Field3) — DATETIME — NOT NULL
  • endDate (Field4) — DATETIME — NOT NULL
  • hashtagId (Key3) — INT UNSIGNED — Foreign key → Hashtag.hashtagId — NOT NULL
  • searchWord (Field6) — BLOB — NOT NULL

User

  • userId — INT UNSIGNED — Primary key — NOT NULL
  • password — VARCHAR
  • userName — VARCHAR(200)
  • profileImage (Field2) — VARCHAR
  • oauthName — VARCHAR(20)
  • oauthToken — VARCHAR
  • colorTheme (Field) — VARCHAR(100)
  • createdAt — DATETIME
  • updatedAt — DATETIME
  • deletedAt — DATETIME