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