asd

Tables (6)

mal_user

  • id — varchar(15) — NOT NULL
  • mal_time — timestamp

movies

  • id — varchar(15) — NOT NULL
  • title — varchar(30) — NOT NULL
  • director — varchar(30) — NOT NULL
  • genre — varchar(20) — NOT NULL
  • rel_date — date — NOT NULL

reviews

  • mid — varchar(15) — Primary key — NOT NULL
  • uid — varchar(15) — Primary key — NOT NULL
  • ratings — smallint — NOT NULL
  • review — text — NOT NULL
  • rev_time — timestamp — NOT NULL

ties

  • id — varchar(15) — Primary key — NOT NULL
  • opid — varchar(15) — Primary key — NOT NULL
  • tie — varchar(8) — NOT NULL

user_info

  • id — varchar(15) — NOT NULL
  • name — varchar(15)
  • email — domain_email
  • reg_date — date — NOT NULL

users

  • id — varchar(15) — NOT NULL
  • password — varchar(20) — NOT NULL
  • role — varchar(10) — NOT NULL