WILT

Tables (16)

Bookmark

  • user_id — INT — Foreign key → Users.id — NOT NULL
  • til_id — INT — Foreign key → Til.id
  • 생성일 (create_date) — TIMESTAMP
  • 활성화 (is_activate) — BOOL

Bookmark (Bookmark_)

  • id — AuthField — Primary key — NOT NULL
  • user_id (user) — CharField(20) — Foreign key → WiltUser.UID — NOT NULL
  • til_id (til) — AuthField — Foreign key → Til.id — NOT NULL
  • 생성일 (date_created) — DateTimeField — NOT NULL

Clap

  • user_id — INT — Foreign key → Users.id — NOT NULL
  • til_id (til_) — INT — Foreign key → Til.id
  • 생성일 (create_date) — TIMESTAMP
  • 활성화 (is_activate) — BOOL — NOT NULL

Clap (Clap_)

  • id — AuthField — Primary key — NOT NULL
  • user_id (user) — CharField(20) — Foreign key → WiltUser.UID — NOT NULL
  • til_id (til) — AuthField — Foreign key → Til.id — NOT NULL
  • 생성일 (date_created) — DateTimeField — NOT NULL

Devices

  • device_id (id) — INT — Primary key — NOT NULL
  • id (user_id) — INT — Foreign key → Users.id — NOT NULL
  • type — ENUM('APPLE')
  • device_token — VARCHAR(120)
  • created_at — TIMESTAMP
  • deleted_at — TIMESTAMP

Interest_companies

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • 관심회사 (company_name) — VARCHAR(20)

Interest_jobs

  • id — INT — Primary key — NOT NULL
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • 관심직무 (job_title) — VARCHAR(20)

TaggedItem (TaggedItem_)

  • object_id — PositiveIntegerField — Primary key — NOT NULL
  • tag — CharField(20) — Foreign key → Tags.name — NOT NULL — Unique
  • til (content_type) — ContentType — Foreign key → Til.id — NOT NULL

Tags

  • id — INT — Primary key — NOT NULL
  • 태그 이름 (tag_name) — VARCHAR(20)

Tags (Tags_)

  • name — CharField(20) — Primary key — NOT NULL — Unique

Til

  • id — INT — Primary key
  • user_id — INT — Foreign key → Users.id — NOT NULL
  • 카테고리 (category) — VARCHAR(20)
  • 제목 (title) — VARCHAR(20)
  • 내용 (content) — LONGTEXT(n)
  • 생성일 (create_date) — TIMESTAMP
  • 공개여부 (is_private) — BOOL

Til (Til_)

  • id — AuthField — Primary key — NOT NULL
  • 작성자 (author) — CharField(20) — Foreign key → WiltUser.UID — NOT NULL
  • 카테고리 (category) — CharField(20)
  • 제목 (title) — TextField — NOT NULL
  • 내용 (content) — TextField
  • 생성일 (data_created) — DateTimeField — NOT NULL
  • 공개여부 (is_public) — BooleanField — NOT NULL

Til_Tag

  • Til_id (til_id) — INT — Foreign key → Til.id — NOT NULL
  • tag_id — INT — Foreign key → Tags.id
  • 생성일 (create_time) — TIMESTAMP

User_Tag

  • id — INT — Foreign key → Users.id — NOT NULL
  • id (id2) — INT — Foreign key → Tags.id — NOT NULL

Users

  • id — INT — Primary key — NOT NULL
  • 닉네임 (user_name) — VARCHAR(20)
  • 재직회사 (company_name) — VARCHAR(20) — NOT NULL
  • 직무 (job_title) — VARCHAR(20) — NOT NULL
  • 연차 (c_year) — INT — NOT NULL

WiltUser (WiltUser_)

  • UID (id) — CharField(20) — Primary key — NOT NULL
  • user name (display_name) — CharField(20)
  • email — EmailField — NOT NULL — unique
  • is_active — BooleanField — NOT NULL — Designates whether this user should be treated as active. Unselect this instead of deleting accounts.
  • is_staff — BooleanField — 스태프는 관리자 권한, Firebase에서 정의
  • is_superuser — BooleanField — NOT NULL — 슈퍼유저 권한, Firebase에서 정의
  • 가입일 (date_joined) — DateTimeField — NOT NULL
  • 재직회사 (company_name) — CharField(20)
  • 직무 (job_title) — CharField(20)
  • 연차 (career_year) — DeciamlField — max_digits=3, decimal_places=0
  • 소개 (description) — TextField
  • 웹사이트 (web_link) — TextField