CEOS_everytime

Tables (7)

Comment (posts2)

  • comment_id (pk) — not_null, unique — Primary key — NOT NULL
  • post_id (fk) — not_null,unique — Foreign key → Post.post_id — NOT NULL
  • profile_id (fk2) — not_null, unique — Foreign key → Profile.profile_id — NOT NULL
  • content (내용)
  • is_anony (익명여부) — default=True
  • create_at (작성일) — auto_now_add
  • updated_at (수정일) — auto_now

Friend (Untitled3)

  • Friend_id (Key) — not_null, unique — Primary key — NOT NULL
  • user (user_id) — Primary key — NOT NULL
  • friend (friend_id) — Foreign key → Profile.profile_id — NOT NULL

Post (posts)

  • post_id (pk) — not_null,unique — Primary key — NOT NULL
  • profile_id (fk) — not_null, unique — Foreign key → Profile.profile_id — NOT NULL
  • content (내용)
  • is_anony (익명여부) — default=True
  • is_question (질문여부)
  • image (이미지)
  • create_at (작성일) — auto_now_add
  • updated_at (수정일) — auto_now

Profile (accounts)

  • profile_id (pk) — not_null, unique — Primary key — NOT NULL
  • user (fk) — not_null, unique — Foreign key → User.user_id — NOT NULL
  • nickname (닉네임) — unique, not_null
  • university (대학t) — unique, not_null
  • enter_year (입학년도) — 2000~2030
  • create_at (생성일) — auto_now_add
  • updated_at (수정일) — auto_now

Subject (timetables2)

  • subject_id (pk) — not_null, unique — Primary key — NOT NULL
  • timetable_id (fk) — not_null, unique — Foreign key → Timetable.timetable_id — NOT NULL
  • name (과목이름)
  • teacher (교수님이름)
  • day (요일) — WEEK_CHOICE중 선택
  • start_time (시작시간)
  • end_time (끝시간)

Timetable (timetables)

  • timetable_id (pk) — not_null, unique — Primary key — NOT NULL
  • profile_id (fk) — not_null, unique — Foreign key → Profile.profile_id — NOT NULL
  • title (제목)
  • created_at (생성일) — auto_now_add
  • updated_at (수정일) — auto_now

User (django기본모델)

  • user_id (pk) — not_null, unique — Primary key — NOT NULL
  • username (아이디) — unique, not_null
  • password1 (비밀번호1)
  • password (비밀번호2) — password1과 비교
  • email (이메일)