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