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