ERD

Tables (3)

answer (Untitled)

  • Key — Foreign key → user.Key — NOT NULL
  • Key (Key2) — Foreign key → post.Key — NOT NULL
  • Key (Key22) — Foreign key → post.Key — NOT NULL
  • answer_Id (Field) — long
  • vote (Field2) — Integer
  • answer_body (Field3) — String
  • Answer_Status (Field4) — enum

post (Untitled2)

  • Key — Primary key — NOT NULL
  • Key (Key2) — Foreign key → user.Key — NOT NULL
  • post_Id (Field) — long
  • title (Field2) — String
  • Post_body (Field3) — String
  • vote (Field4) — Integer
  • Field5

user

  • Key — Primary key — NOT NULL
  • id (Field) — long
  • username (Field2) — String
  • password (Field5) — String
  • email (Field4) — String
  • UserStatus (Field3) — UserStatus
  • role (Field6) — list