a_month_pj_0802

IMCA ERD

Tables (10)

Category

  • Pk (pk) — Primary key — NOT NULL
  • Free board (free_board) — CharField — NOT NULL
  • Review board (review_board) — CharField — NOT NULL
  • Trade board (trade_board) — CharField — NOT NULL
  • Pk (pk2) — Foreign key → Community(Free board).Pk — NOT NULL

Community(Free board) (Community)

  • Pk (pk) — Primary key — NOT NULL
  • Title (title) — CharField — NOT NULL
  • CheckNum (check_num) — PositiveIntegerField — NOT NULL
  • Contents (contents) — TextField — NOT NULL
  • User (user) — CharField — NOT NULL
  • Reviews (reviews) — ForeignKey
  • Pk (pk2) — Foreign key → User.Pk — NOT NULL

Memo

  • Pk (pk) — Primary key — NOT NULL
  • Title (title) — CharField — NOT NULL
  • Contents (contents) — TextField — NOT NULL
  • Pk (pk2) — Foreign key → Private calender.Pk — NOT NULL

Private calender (Private_calender)

  • Pk (pk) — Primary key — NOT NULL
  • Start (start) — CharField
  • End (end) — CharField
  • Pk (pk2) — Foreign key → User.Pk — NOT NULL

Report

  • Pk (pk) — Primary key — NOT NULL
  • rereview (Key) — Foreign key → Reviews_review.rereview — NOT NULL
  • Id (id) — ForeignKey — NOT NULL
  • Title (title) — CharField — NOT NULL
  • Contents (contents) — TextField — NOT NULL
  • Pk (pk2) — Foreign key → User.Pk — NOT NULL
  • Pk (pk3) — Foreign key → Community(Free board).Pk — NOT NULL
  • Pk (pk4) — Foreign key → Review.Pk — NOT NULL

Review

  • Pk (pk) — Primary key — NOT NULL
  • Created (created) — DateTimeField — NOT NULL
  • Updated (updated) — DateTimeField — NOT NULL
  • Pk (pk2) — Foreign key → Category.Pk — NOT NULL

Reviews_review

  • rereview (Key) — Primary key — NOT NULL
  • Contents (rere_contents)
  • Pk (pk) — Foreign key → Review.Pk — NOT NULL

User

  • Pk (pk) — Primary key
  • ID (id) — CharField — NOT NULL
  • PW (pw) — CharField — NOT NULL
  • Nickname (nick_name) — CharField — NOT NULL
  • Name (name) — CharField — NOT NULL
  • Email (email) — EmailField — NOT NULL
  • Gender (gender) — CharField
  • ProfileImg (profile_img) — ImageField
  • Field
  • Field2
  • Field3

User (유저)

  • Pk (pk) — Primary key — NOT NULL
  • ID (id) — CharField — NOT NULL
  • PW (pw) — CharField — NOT NULL
  • Nickname (nick_name) — CharField — NOT NULL
  • Name (name) — CharField — NOT NULL
  • Email (email) — EmailField — NOT NULL
  • Gender (gender) — CharField
  • ProfileImg (profile_img) — ImageField
  • Field
  • Field2
  • Field3

Youtube_Page (Untitled)

  • Field
  • Field2
  • Field3
  • Field4