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