blog
Tables (60)
account_emailaddress
- id — integer
- email — varchar(254) — NOT NULL
- verified — boolean — NOT NULL
- primary — boolean — NOT NULL
- user_id — bigint — NOT NULL
account_emailconfirmation
- id — integer
- created — timestamp — NOT NULL
- sent — timestamp
- email_address_id — integer — NOT NULL
accounts_customuser
- id — bigint
- password — varchar(128) — NOT NULL
- last_login — timestamp
- is_superuser — boolean — NOT NULL
- first_name — varchar(150) — NOT NULL
- last_name — varchar(150) — NOT NULL
- is_staff — boolean — NOT NULL
- is_active — boolean — NOT NULL
- email — varchar(254) — NOT NULL
- created_at — timestamp — NOT NULL
- introduction — text
- nickname — varchar(20) — NOT NULL
- phone_number — varchar(20)
- updated_at — timestamp — NOT NULL
accounts_customuser_groups
- id — bigint
- customuser_id — bigint — NOT NULL
- group_id — integer — NOT NULL
accounts_customuser_students
- id — bigint
- from_customuser_id — bigint — NOT NULL
- to_customuser_id — bigint — NOT NULL
accounts_customuser_user_permissions
- id — bigint
- customuser_id — bigint — NOT NULL
- permission_id — integer — NOT NULL
auth_group
- id — integer — NOT NULL
- name — varchar(150) — NOT NULL
auth_group_permissions
- id — integer — NOT NULL
- group_id — integer — NOT NULL
- permission_id — integer — NOT NULL
auth_permission
- id — integer — NOT NULL
- content_type_id — integer — NOT NULL
- codename — varchar(100) — NOT NULL
- name — varchar(255) — NOT NULL
auth_user_groups
- id — integer — NOT NULL
- user_id — integer — NOT NULL
- group_id — integer — NOT NULL
auth_user_user_permissions
- id — integer — NOT NULL
- user_id — integer — NOT NULL
- permission_id — integer — NOT NULL
authtoken_token
- created — timestamp — NOT NULL
- user_id — bigint — NOT NULL
courses_assignment
- id — bigint
- question — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- topic_id — bigint — NOT NULL
courses_course
- id — bigint
- title — varchar(255) — NOT NULL
- description — jsonb — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- curriculum_id — bigint
- category — varchar(255) — NOT NULL
- skill_level — varchar(255) — NOT NULL
- short_description — text — NOT NULL
- price — integer — NOT NULL
- author_id — bigint — NOT NULL
courses_curriculum
- id — bigint
- name — varchar(255) — NOT NULL
- description — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- price — integer — NOT NULL
- category — varchar(255) — NOT NULL
- skill_level — varchar(255) — NOT NULL
- author_id — bigint — NOT NULL
courses_lecture
- id — bigint
- title — varchar(255) — NOT NULL
- order — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- course_id — bigint — NOT NULL
courses_multiplechoicequestion
- id — bigint
- question — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- topic_id — bigint — NOT NULL
courses_multiplechoicequestionchoice
- id — bigint
- choice — varchar(255) — NOT NULL
- is_correct — boolean — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- question_id — bigint — NOT NULL
courses_topic
- id — bigint
- title — varchar(255) — NOT NULL
- order — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- lecture_id — bigint — NOT NULL
- is_premium — boolean — NOT NULL
- type — varchar(255) — NOT NULL
django_admin_log
- id — integer — NOT NULL
- object_id — text
- object_repr — varchar(200) — NOT NULL
- action_flag — smallint — NOT NULL
- change_message — text — NOT NULL
- content_type_id — integer
- user_id — integer — NOT NULL
- action_time — datetime — NOT NULL
- check — ("action_flag" >= 0)
django_content_type
- id — integer — NOT NULL
- app_label — varchar(100) — NOT NULL
- model — varchar(100) — NOT NULL
django_migrations
- id — integer — NOT NULL
- app — varchar(255) — NOT NULL
- name — varchar(255) — NOT NULL
- applied — datetime — NOT NULL
django_session
- session_key — varchar(40) — NOT NULL
- session_data — text — NOT NULL
- expire_date — datetime — NOT NULL
django_site
- id — integer
- domain — varchar(100) — NOT NULL
- name — varchar(50) — NOT NULL
jwtauth_blacklistedtoken
- id — bigint
- token — varchar(500) — NOT NULL
- blacklisted_at — timestamp — NOT NULL
- token_type — varchar(10) — NOT NULL
- user_id — bigint — NOT NULL
materials_image
- id — bigint
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- course_id — bigint
- user_id — bigint
- image_url — varchar(200) — NOT NULL
- author_id — bigint
materials_video
- id — bigint
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- topic_id — bigint
- course_id — bigint
- video_url — varchar(200) — NOT NULL
materials_videoeventdata
- id — bigint
- event_type — varchar(20) — NOT NULL
- duration — double — NOT NULL
- current_time — double — NOT NULL
- timestamp — timestamp — NOT NULL
- video_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
payments_cart
- id — bigint
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- user_id — bigint — NOT NULL
payments_cartitem
- id — bigint
- quantity — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- cart_id — bigint — NOT NULL
- curriculum_id — bigint
- course_id — bigint
payments_order
- id — bigint
- order_status — varchar(10) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- user_id — bigint — NOT NULL
payments_orderitem
- id — bigint
- quantity — integer — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- course_id — bigint
- curriculum_id — bigint
- order_id — bigint — NOT NULL
- expiry_date — timestamp
payments_payment
- id — bigint
- payment_status — varchar(10) — NOT NULL
- amount — integer — NOT NULL
- order_id — bigint — NOT NULL
- user_id — bigint — NOT NULL
- paid_at — timestamp
- transaction_id — varchar(255)
- billing_address_id — bigint
- cancelled_at — timestamp
- created_at — timestamp
- updated_at — timestamp — NOT NULL
- metadata — jsonb — NOT NULL
payments_userbillingaddress
- id — bigint
- country — varchar(50) — NOT NULL
- main_address — varchar(255) — NOT NULL
- detail_address — varchar(255) — NOT NULL
- postal_code — varchar(20) — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp — NOT NULL
- user_id — bigint — NOT NULL
- is_default — boolean — NOT NULL
post_category
- id — integer — NOT NULL
- name — varchar(50) — NOT NULL
post_post
- id — integer — NOT NULL
- title — varchar(255) — NOT NULL
- description — varchar(255) — NOT NULL
- content — text — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- status — bool — NOT NULL
- author_id — integer — NOT NULL
- category_id — bigint — NOT NULL
- image_id — bigint
- check — ((JSON_VALID("content")
post_post_tags
- id — integer — NOT NULL
- post_id — bigint — NOT NULL
- tag_id — bigint — NOT NULL
post_tag
- id — integer — NOT NULL
- name — varchar(50) — NOT NULL
social_auth_association
- id — bigint
- server_url — varchar(255) — NOT NULL
- handle — varchar(255) — NOT NULL
- secret — varchar(255) — NOT NULL
- issued — integer — NOT NULL
- lifetime — integer — NOT NULL
- assoc_type — varchar(64) — NOT NULL
social_auth_code
- id — bigint
- email — varchar(254) — NOT NULL
- code — varchar(32) — NOT NULL
- verified — boolean — NOT NULL
- timestamp — timestamp — NOT NULL
social_auth_nonce
- id — bigint
- server_url — varchar(255) — NOT NULL
- timestamp — integer — NOT NULL
- salt — varchar(65) — NOT NULL
social_auth_partial
- id — bigint
- token — varchar(32) — NOT NULL
- next_step — smallint — NOT NULL
- backend — varchar(32) — NOT NULL
- timestamp — timestamp — NOT NULL
- data — jsonb — NOT NULL
social_auth_usersocialauth
- id — bigint
- provider — varchar(32) — NOT NULL
- uid — varchar(255) — NOT NULL
- user_id — bigint — NOT NULL
- created — timestamp — NOT NULL
- modified — timestamp — NOT NULL
- extra_data — jsonb — NOT NULL
socialaccount_socialaccount
- id — integer
- provider — varchar(200) — NOT NULL
- uid — varchar(191) — NOT NULL
- last_login — timestamp — NOT NULL
- date_joined — timestamp — NOT NULL
- extra_data — jsonb — NOT NULL
- user_id — bigint — NOT NULL
socialaccount_socialapp
- id — integer
- provider — varchar(30) — NOT NULL
- name — varchar(40) — NOT NULL
- client_id — varchar(191) — NOT NULL
- secret — varchar(191) — NOT NULL
- provider_id — varchar(200) — NOT NULL
- settings — jsonb — NOT NULL
socialaccount_socialapp_sites
- id — bigint
- socialapp_id — integer — NOT NULL
- site_id — integer — NOT NULL
socialaccount_socialtoken
- id — integer
- token — text — NOT NULL
- token_secret — text — NOT NULL
- expires_at — timestamp
- account_id — integer — NOT NULL
- app_id — integer
sqlite_master
- type — TEXT
- name — TEXT
- tbl_name — TEXT
- rootpage — INT
- sql — TEXT
sqlite_sequence
그룹 (Group)
대댓글 (Reply)
- 대댓글아이디 (id) — SERIAL — Primary key — NOT NULL
- 댓글아이디 (comment_id) — SERIAL — Foreign key → 댓글.댓글아이디 — NOT NULL
- 내용 (content) — TEXT — NOT NULL
- 생성일 (created_at) — TIMESTAMP
- 업데이트입 (updated_at) — TIMESTAMP
댓글 (Comment)
- 댓글아이디 (id) — SERIAL — Primary key — NOT NULL
- 내용 (content) — TEXT — NOT NULL
- 생성일 (created_at) — TIMESTAMP
- 업데이트일 (updated_at) — TIMESTAMP
유저 (auth_user)
- 유저아이디 (id) — SERIAL — Primary key — NOT NULL
- 유저이름 (username) — VARCHAR(150) — NOT NULL
- 이메일 (email) — VARCHAR(254) — NOT NULL
- 비밀번호 (password) — VARCHAR(255) — NOT NULL
- 가입일 (date_joined) — TIMESTAMP
- 활성화 (is_active) — BOOLEAN
- 관리자 (is_staff) — BOOLEAN
- last_login — DATETIME
- is_superuser — BOOLEAN
- last_name — VARCHAR(150)
- first_name — varchar(150)
유저프로필 (user_profile)
- id — integer — Primary key — NOT NULL
- 유저아이디 (user_id) — SERIAL — Foreign key → 유저.유저아이디 — NOT NULL
- job_title — varchar(50)
- location — varchar(50)
- bio — text
- birth_date — date
- email — varchar(254)
- address — varchar(255)
- facebook — varchar(200)
- linkedin — varchar(200)
- twitter — varchar(200)
- tistory — varchar(200)
- github — varchar(200)
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
- website — varchar(200)
이미지 (image_image)
- id — integer — Primary key — NOT NULL
- 유저아이디 (user_id) — SERIAL — Foreign key → 유저.유저아이디 — NOT NULL
- image_url — varchar(200) — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
카테고리 (Category)
- 카테고리아이디 (id) — SERIAL — Primary key — NOT NULL
- 카테고리이름 (name) — VARCHAR(50) — NOT NULL
태그 (Tag)
- 태그아이디 (id) — SERIAL — Primary key — NOT NULL
- 태그이름 (name) — VARCHAR(50) — NOT NULL
포스터 (Post)
- 포스터아이디 (id) — SERIAL — Primary key — NOT NULL
- 유저아이디 (author_id) — SERIAL — Foreign key → 유저.유저아이디 — NOT NULL
- 카테고리아이디 (category_id) — SERIAL — Foreign key → 카테고리.카테고리아이디 — NOT NULL
- 썸네일아이디 (image_id) — integer — Foreign key → 이미지.id — NOT NULL
- 제목 (title) — VARCHAR(255) — NOT NULL
- 소개 (description) — VARCHAR(255)
- 내용 (content) — TEXT — NOT NULL
- 생성일 (created_at) — TIMESTAMP
- 업데이트일 (updated_at) — TIMESTAMP
- 상태 (status) — VARCHAR(50)
포스터_태그 (Post_Tag)
- 포스터아이디 (post_id) — SERIAL — Foreign key → 포스터.포스터아이디 — NOT NULL
- 태그아이디 (tag_id) — SERIAL — Foreign key → 태그.태그아이디 — NOT NULL
- 카테고리아이디 (id2) — SERIAL — Foreign key → 포스터.카테고리아이디 — NOT NULL
- id (id3) — integer — Foreign key → 포스터.썸네일아이디 — NOT NULL
포스트 상태 (Post_Status)
- 상태아이디 (id) — SERIAL — Primary key — NOT NULL
- 조회수 (views) — INTEGER
- 좋아요 (likes) — INTEGER
- 생성일 (created_at) — TIMESTAMP
- 업데이트일 (updated_at) — TIMESTAMP