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