HealthLife

Tables (6)

Articles (Articles/Articles)

  • Key (Article_pk) — Primary key — NOT NULL
  • Key (User_pk) — INT — Foreign key → User.Key — NOT NULL
  • category (Category_pk) — ForeignKey — Foreign key → Category.Key — NOT NULL
  • upload_time (작성시간) — DateTimeField — NOT NULL
  • revise_time (수정시간) — DateTimeField
  • title (제목) — CHARFIELD — NOT NULL
  • content (내용) — RichTextUploadingField — NOT NULL
  • like_user (좋아요) — ManytoManyField
  • unlike_user (싫어요) — ManytoManyField
  • comment_count (댓글 카운트) — IntegerField — NOT NULL
  • popular_article (인기글) — CharField — NOT NULL

Category (Articles/Category)

  • Key (Category_pk) — INT — Primary key — NOT NULL
  • name (카테고리 이름) — CHARFIELD — NOT NULL
  • slug (슬러그) — SlugField — NOT NULL

Comment (Articles/Comment)

  • Key (Comment_pk) — INT — Primary key — NOT NULL
  • parent_comment (parent_comment_pk) — Foreignkey — Primary key — NOT NULL
  • User (User_pk) — Foreignkey — Foreign key → User.Key — NOT NULL
  • Article (Article_pk) — Foreignkey — Foreign key → Articles.Key — NOT NULL
  • Article_User (User_pk2) — INT — Foreign key → Articles.Key — NOT NULL
  • upload_time (작성시간) — DateTimeField — NOT NULL
  • revise_time (수정시간) — DateTimeField
  • content (내용) — CHARFIELD — NOT NULL

Hobby (Accounts/Hobby)

  • Key (Hobby_pk) — INT — Primary key — NOT NULL
  • User (User_pk) — INT — Foreign key → User.Key — NOT NULL
  • name (취미이름) — CHARFIELD — NOT NULL

Report (Articles/Report)

  • Key (Report_pk) — INT — Primary key — NOT NULL
  • Key (User_pk) — INT — Foreign key → User.Key — NOT NULL
  • title (제목) — CHARFIELD — NOT NULL
  • Field (이유) — CHARFIELD
  • Field2 (신고_제목) — CHARFIELD — NOT NULL
  • Field (신고_내용) — RichTextUploadingField — NOT NULL
  • Field (신고_유저_닉네임) — CHARFIELD — NOT NULL
  • Field (신고_게시글_pk) — INT — NOT NULL
  • Field (작성시간) — DateTimeField — NOT NULL

User (Accounts/User)

  • Key (User_pk) — INT — Primary key — NOT NULL
  • hobbies (Hobby_pk) — ManytoManyField(Hobby) — Foreign key → Hobby.Key — NOT NULL
  • email (이메일) — EmailField — NOT NULL
  • username (이름) — CHARFIELD — NOT NULL
  • nickname (닉네임) — TEXTFIELD(UNIQUE=True) — NOT NULL
  • invited_Day (생성일자) — DateField(auto_now_add=True) — NOT NULL
  • profile_image (프로필 이미지) — ImageField