asdfadf
Tables (21)
action_point
- id — INT — Primary key — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- category_id — INT — Foreign key → action_point_category.id — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
action_point_category
- id — INT — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- score — INT — NOT NULL
block
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- block_user_id — INT — Foreign key → user.id — NOT NULL
cash_exchange
- id — INT — Primary key — NOT NULL
- cash — INT — NOT NULL
- bank — VARCHAR(20) — NOT NULL
- account_owner — VARCHAR(10) — NOT NULL
- account_number — VARCHAR(100) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
cluster
- id — INT — Primary key — NOT NULL
- title — VARCHAR(20) — Primary key — NOT NULL
comment
- id — INT — Primary key — NOT NULL
- content — VARCHAR(200) — NOT NULL
- is_adoption — TINYINT — NOT NULL
- video_id — INT — Foreign key → video.id — NOT NULL
- parent_id — INT — Foreign key → comment.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- deleted_at — TIMESTAMP
follow
- following — INT — Primary key — NOT NULL
- follower — INT — Foreign key → user.id — NOT NULL
hash_tag
- id — INT — Primary key — NOT NULL
- title — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- question_id — INT — Foreign key → video.id — NOT NULL
inquiry
- id — INT — Primary key — NOT NULL
- title — VARCHAR(100) — NOT NULL
- description — TEXT
- user_id — INT — Foreign key → user.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- inquiry_category_id — INT — Foreign key → inquiry_category.id — NOT NULL
inquiry_category
- id — INT — Primary key — NOT NULL
- title — VARCHAR(20) — NOT NULL
interest
- user_id — INT — Foreign key → user.id — NOT NULL
- category_id — INT — Foreign key → interest_category.id — NOT NULL
interest_category
- id — INT — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
iq
- user_id — INT — Foreign key → user.id — NOT NULL
- cur_cnt — BIGINT — NOT NULL
- tot_cnt — BIGINT — NOT NULL
iq_payment_category
- id — INT — Primary key — NOT NULL
- name — varchar(20)
iq_payment_history
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- created_at — TIMESTAMP
- category_id — INT — Foreign key → iq_payment_category.id — NOT NULL
- amount — INT — NOT NULL
like
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- video_id — INT — Foreign key → video.id — NOT NULL
report
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- description — TEXT
- video_id — INT — Foreign key → video.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- comment_id — INT — Foreign key → comment.id
- passed — TINYINT — NOT NULL
tier
- user_id — INT — Foreign key → user.id — NOT NULL
- category_id — INT — Foreign key → tier_category.id — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
tier_category
- id — INT — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
- next_tot_iq — INT — NOT NULL
- next_adoption_cnt — INT — NOT NULL
- image_url — VARCHAR(2000) — NOT NULL
user
- id — INT — Primary key — NOT NULL
- provider — VARCHAR(10) — NOT NULL
- email — VARCHAR(320) — NOT NULL
- profile — VARCHAR(2000)
- name — VARCHAR(30) — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- last_accessed_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- adoption_cnt — INT — NOT NULL
- expo_token — VARCHAR(1024)
video
- id — INT — Primary key — NOT NULL
- description — TEXT — NOT NULL
- title — VARCHAR(100) — NOT NULL
- video_url — VARCHAR(2000) — NOT NULL
- question_id — INT — Foreign key → video.id
- user_id — INT — Foreign key → user.id — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- is_adoption — TINYINT — NOT NULL
- updated_at — TIMESTAMP — NOT NULL
- deleted_at — TIMESTAMP
- thumbnail — VARCHAR(255)
- compensation — INT
- views — BIGINT — NOT NULL