bulletin_board
Tables (6)
Post (CopyOfUntitled)
- post_id — PK — Primary key — NOT NULL
- user (user_id) — PK — Foreign key → User.user_id — NOT NULL
- post_type_id — PK — Foreign key → PostType.post_type_id — NOT NULL
- title — charfield
- content — textfield
- created_at — datetimefield
- updated_at — datetimefield
PostType (Untitled5)
- post_type_id — PK — Primary key — NOT NULL
- post_type — charfiled
PostUpdatedLog (Untitled3)
- post_update_log_id — PK — Primary key — NOT NULL
- user_id — PK — Foreign key → User.user_id — NOT NULL
- id (user_type_id) — FK — Foreign key → User.id — NOT NULL
- updated_at — datetimefiled
User (Untitled)
- user_id — PK — Primary key — NOT NULL
- id (user_type_id) — FK — Foreign key → UserType.id — NOT NULL
- username — charfield
- password — charfiled
- gender — charfiled
- age — integerfiled
- phone — RegexValidator
- joined_date — datetimefiled
UserLog (Untitled4)
- user_log_id — PK — Primary key — NOT NULL
- user_id — PK — Foreign key → User.user_id — NOT NULL
- id (user_type_id) — FK — Foreign key → User.id — NOT NULL
- login_date — datetimefield
UserType (Untitled2)
- id (user_type_id) — PK — Primary key — NOT NULL
- user_type — charflied