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