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