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