cells

Tables (3)

MEDIA

  • mediaid — integer — Primary key — NOT NULL
  • postid — integer — Foreign key → POST.postid — NOT NULL
  • file_type — enum(image, video)
  • file_path — varchar(255)
  • timestamp — timestamp

POST

  • postid — integer — Primary key — NOT NULL
  • userid — interger — Foreign key → USER.userid — NOT NULL
  • title — varchar(255)
  • timestamp — TIMESTAMP
  • lasttimestamp — TIMESTAMP

USER

  • userid — interger — Primary key — NOT NULL
  • username — varchar(255)
  • passwd — varchar(255)
  • email — varchar(255)
  • timestamp — TIMESTAMP