ALGOCEAN

Tables (8)

Answers

  • Id — INT
  • UserId — INT
  • QuestionId — INT
  • Content — TEXT
  • VideoLink — VARCHAR(255)
  • IsAdopted — BOOLEAN
  • CreatedAt — DATETIME
  • UpdatedAt — DATETIME
  • IsDeleted — BOOLEAN
  • DeletedAt — DATETIME

Delete_History

  • Id — INT
  • OriginalTableName — VARCHAR(255)
  • OriginalDataId — INT
  • DeleteDate — DATETIME

Items

  • Id — INT
  • Name — VARCHAR(255)
  • Description — TEXT
  • Price — INT

Likes

  • Id — INT
  • UserId — INT
  • QuestionId — INT
  • IsLiked — BOOLEAN

Point_History

  • Id — INT
  • UserId — INT
  • PointChange — INT
  • Reason — VARCHAR(255)
  • ChangeDate — DATETIME

Questions

  • Id — INT
  • UserId — INT
  • Title — VARCHAR(255)
  • Content — TEXT
  • Tag — VARCHAR(255)
  • OriginalLink — VARCHAR(255)
  • IsAdopted — BOOLEAN
  • CreatedAt — DATETIME
  • UpdatedAt — DATETIME
  • IsDeleted — BOOLEAN
  • DeletedAt — DATETIME

User_Items

  • Id — INT
  • UserId — INT
  • ItemId — INT
  • PurchaseDate — DATETIME

Users

  • Id — INT
  • UserId — VARCHAR(255)
  • Password — VARCHAR(255)
  • Nickname — VARCHAR(255)
  • ProfileImage — VARCHAR(255)
  • Points — INT
  • IsDeleted — BOOLEAN
  • DeletedAt — DATETIME