Pictchase

Tables (6)

pictFile (Untitled4)

  • pictFileId — INT — Primary key — NOT NULL
  • userMissionId — INT — Foreign key → userMission.userMissionId — NOT NULL
  • pictMissionId (pictMissionId2) — INT — Foreign key → userMission.pictMissionId — NOT NULL
  • pictFileSize — VARCHAR
  • pictFileName — VARCHAR
  • pictFileRoute — VARCHAR

pictMission (Untitled2)

  • pictMissionId — INT — Primary key — NOT NULL
  • pictMissionName — VARCHAR
  • pictMissionContent — VARCHAR

userG (CopyOfUntitled)

  • userGId (userGid) — INT — Primary key — NOT NULL
  • userGooglemail — VARCHAR
  • userGooglename — VARCHAR
  • userGoogleNickname — VARCHAR
  • userGNumber — VARCHAR
  • userBirth — DATETIME
  • userCreatedAt — DATETIME
  • userUpdatedAt — DATETIME
  • userDeletedAt — DATETIME

userInsta (Untitled)

  • userInstaId — INT — Primary key — NOT NULL
  • userInstamail — VARCHAR
  • userInstaname — VARCHAR
  • userInstaNickname — VARCHAR
  • userInstaNumber — VARCHAR
  • userBirth — DATETIME
  • userCreatedAt — DATETIME
  • userUpdatedAt — DATETIME
  • userDeletedAt — DATETIME

userMission (Untitled3)

  • userMissionId — INT — Primary key — NOT NULL
  • pictMissionId (pictMissionId2) — INT — Foreign key → pictMission.pictMissionId — NOT NULL
  • userMissionCreatedAt — DATETIME
  • userMissionBoolean — BOOLEAN
  • userId — INT — Foreign key → userPictchase.userId — NOT NULL

userPictchase (userPictachase)

  • userId — INT — Primary key — NOT NULL
  • userPictId — VARCHAR
  • userPictname — VARCHAR
  • userNickname — VARCHAR