GlowPick
Tables (7)
Picture
- pictureId (Key) — number — Primary key — NOT NULL
- folderId (Key2) — number — Foreign key → UserFolder.folderId — NOT NULL
- userId (Key3) — number — Foreign key → UserFolder.userId — NOT NULL
- pictureName (Field) — string
- create_at (Field2) — timestamp
- update_at (Field3) — timestamp
- deleted_at (Field4) — timestamp
PictureTag
- tagId (Key) — number — Primary key — NOT NULL
- pictureId (Key2) — number — Foreign key → Picture.pictureId — NOT NULL
- tagName (Field) — string
- create_at (Field2) — timestamp
- update_at (Field3) — timestamp
- tagType (Key3) — number — Foreign key → TagType.tagType — NOT NULL
TagType
- tagType (Key) — number — Primary key — NOT NULL
- tagTypeName (Field) — string
- create_at (Field2) — timestamp
- update_at (Field3) — timestamp
User
- id (Key) — number — Primary key — NOT NULL
- name (Field) — string
- create_at (Field2) — timestamp
- update_at (Field3) — timestamp
UserFolder
- folderId (Key) — number — Primary key — NOT NULL
- userId (Key2) — number — Foreign key → User.id — NOT NULL
- folderName (Field) — string
- folderUrl (Field2) — string
- create_at (Field4) — timestamp
- update_at (Field5) — timestamp
UserFolderPoint
- folderId (Key) — number — Primary key — NOT NULL
- userId (Key2) — number — Foreign key → User.id — NOT NULL
- point (Field) — number
- create_at (Field2) — timestamp
- update_at (Field3) — timestamp
UserPointHistory
- logId (Key) — number — Primary key — NOT NULL
- userId (Key2) — number — Primary key — NOT NULL
- create_at (Key3) — timestamp — Primary key — NOT NULL
- folderId (Field) — number
- consumedPoint (Field2) — nymber