V1 MyInstagram
Tables (6)
RefreshToken
- Refresh_Token_Id (RefreshTokenId) — bigint — Primary key — NOT NULL
- Accounts Id (accounts_id) — bigint — Foreign key → accounts.Accounts Id — NOT NULL
- Token (token) — VARCHAR(255)
- Created Date (created_date) — DATETIME
- Modified Date (modified_date) — DATETIME
accounts
- Accounts Id (accounts_id) — bigint — Primary key — NOT NULL
- Username (username) — VARCHAR(255)
- Password (password) — VARCHAR(255)
- Profile Name (profile_name) — VARCHAR(255)
- Created Date (created_date) — DATETIME
- Modified Date (modified_date) — DATETIME
- Profile Image File Id (profile_image_file_id) — bigint — Foreign key → files.FIles Id — NOT NULL
accountsRole
- Accounts Role Id (accounts_role_id) — bigint — Primary key — NOT NULL
- Accounts Id (accounts_id2) — bigint — Foreign key → accounts.Accounts Id — NOT NULL
- Role Id (role_id2) — bigint — Foreign key → role.Role Id — NOT NULL
- deleted — bit(1)
- Created Date (created_date) — DATETIME
- Modified Date (modified_date) — DATETIME
files
- FIles Id (files_id) — bigint — Primary key — NOT NULL
- File Path (file_path) — VARCHAR(255)
- File Name (fileName) — binary
- File Ext (file_ext) — VARCHAR(255)
- Real File Name (real_file_name) — VARCHAR(255)
- Created Date (created_date) — DATETIME
- Modified Date (modified_date) — DATETIME
mail
- Mail Id (mail_id) — bigint — Primary key — NOT NULL
- Username (username) — VARCHAR(255)
- AuthCode (auth_code) — VARCHAR(255)
- Created Date (created_date) — DATETIME
- Modified Date (modified_date) — DATETIME
- Accounts Id (accounts_id) — bigint — Foreign key → accounts.Accounts Id — NOT NULL
role
- Role Id (role_id) — bigint — Primary key — NOT NULL
- name — VARCHAR(255)
- type — VARCHAR(255)
- deleted — bit(1)
- Created Date (created_date) — DATETIME
- Modified Date (modified_date) — DATETIME