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 (이메일)