Bulletin_Board

Tables (4)

Answer (pybo_answer)

  • answer_id (id) — integer — Primary key — NOT NULL
  • question_id (id2) — integer — Foreign key → Question.question_id — NOT NULL
  • user_id (id3) — integer — Foreign key → User.user_id — NOT NULL
  • content (Field) — text
  • create_date (Field2) — datetime
  • modify_date (Field4) — datetime

Comment (pybo_comment)

  • comment_id (id) — integer — Primary key — NOT NULL
  • answer_id (id2) — integer — Foreign key → Answer.answer_id — NOT NULL
  • question_id (id5) — integer — Foreign key → Question.question_id — NOT NULL
  • user_id (id3) — integer — Foreign key → User.user_id — NOT NULL
  • user_id (id32) — integer — Foreign key → Answer.user_id — NOT NULL
  • content (Field) — text
  • create_date (Field2) — datetime
  • modify_date (Field3) — varchar(128)

Question (pybo_question)

  • question_id (id) — integer — Primary key — NOT NULL
  • author_id (id2) — integer — Foreign key → User.user_id — NOT NULL
  • subject (Field) — varchar(200)
  • content (Field2) — text
  • create_date (Field3) — datetime
  • modify_date (Field4) — datetime

User (auth_user)

  • user_id (id) — integer — Primary key — NOT NULL
  • password (Field) — varchar(128)
  • last_login (Field1) — datetime
  • is_superuser (Field2) — boolean
  • username (Field3) — varchar(150)
  • first_name (Field9) — varchar(150)
  • last_name (Field4) — varchar(150)
  • email (Field5) — varchar(254)
  • is_staff (Field6) — boolean
  • is_active (Field7) — boolean
  • date_joined (Field8) — datetime