Literature

Tables (6)

Follow (회원 구독)

  • id (Key) — bigint — Primary key — NOT NULL
  • follower (Key2) — bigint — Foreign key → User.id — NOT NULL
  • following (Key3) — bigint — Foreign key → User.id — NOT NULL
  • created_at (Field) — datetime

Like (게시글 추천)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • post_id (Key3) — bigint — Foreign key → Post.id — NOT NULL
  • created_at (Field3) — datetime

Post (게시글)

  • id (Key) — bigint — Primary key — NOT NULL
  • author (Key2) — bigint — Foreign key → User.id — NOT NULL
  • tags (Key4) — bigint — Foreign key → Tag.id — NOT NULL
  • title (Field) — varchar(20)
  • type (Field2) — bigint
  • created_at (Field4) — datetime
  • updated_at (Field5) — datetime
  • content (Field3) — text

Profile (회원 프로필)

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id (Key2) — bigint — Foreign key → User.id — NOT NULL
  • nickname (Field2) — varchar(20)
  • birth (Field3) — date
  • bio (Field4) — text

Tag (게시글 태그)

  • id (Key) — bigint — Primary key — NOT NULL
  • name (Field) — varchar

User (회원 아이디)

  • id (Key) — bigint — Primary key — NOT NULL
  • email (Field) — varchar(255)
  • password (Field2) — varchar(128)
  • date_joined (Field3) — timestamp
  • last_login (Field4) — timestamp
  • is_active (Field5) — boolean
  • is_superuser (Field6) — boolean
  • is_staff (Field7) — boolean