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