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