try

Tables (10)

block_user

  • id — char(26) — Primary key — NOT NULL
  • block_user_id — char(26) — Foreign key → user_profile_type.id — NOT NULL
  • user_id — char(26) — NOT NULL
  • created_id — char(26)
  • updated_id — char(26)
  • deleted_id — char(26)
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean
  • deleted_at — timestamp

chat_knock

  • chat_id — char(26) — Foreign key → chat_message_counts.chat_id — NOT NULL
  • user_id — char(26) — Foreign key → chat_message_counts.user_id — NOT NULL
  • last_knock_at — TIMESTAMP

chat_message_counts

  • chat_id — VARCHAR(255) — Primary key — NOT NULL
  • user_id — char(26) — Foreign key → user.id — NOT NULL
  • daily_count — INT
  • last_sent_at — TIMESTAMP

customer_answer

  • id — char(26) — Primary key — NOT NULL
  • question_id — char(26) — Foreign key → customer_service.id — NOT NULL
  • user_id — char(26) — Foreign key → customer_service.user_id — NOT NULL
  • content — varchar(255)
  • admin_id — char(26)

customer_service

  • id — char(26) — Primary key — NOT NULL
  • user_id — char(26) — Foreign key → user.id — NOT NULL
  • title — VARCHAR(50)
  • content — varchar(255)
  • date — date
  • category — VARCHAR(50)
  • created_id — char(26)
  • updated_id — char(26)
  • deleted_id — char(26)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

report

  • id — char(26) — Primary key — NOT NULL
  • user_id — char(26) — Foreign key → user.id — NOT NULL
  • chat_id — char(26) — Foreign key → chat_message_counts.chat_id — NOT NULL
  • user_id (user_id2) — char(26) — Foreign key → chat_message_counts.user_id — NOT NULL
  • report_type — varchar(50)
  • created_id — char(27)
  • updated_id — char(27)
  • deleted_id — char(27)
  • created_at — timestamp
  • updated_at — timestamp
  • deleted_at — timestamp

subscribe

  • id — char(26) — Primary key — NOT NULL
  • user_id — char(26) — Foreign key → user.id — NOT NULL
  • is_subscribe — boolean
  • created_id — char(26)
  • updated_id — char(26)
  • created_at — timestamp
  • updated_at — timestamp

user

  • id — char(26) — Primary key — NOT NULL
  • email — VARCHAR(255)
  • nickname — VARCHAR(255)
  • username — VARCHAR(255)
  • password — VARCHAR(255)
  • state — VARCHAR(255)
  • is_email_verified — boolean
  • is_phone_no_verified — boolean
  • created_id — char(26)
  • updated_id — char(26)
  • deleted_id — char(26)
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean
  • deleted_at — timestamp

user_alert

  • id — char(26) — Foreign key → user.id — NOT NULL
  • is_live_stream — boolean
  • is_comm_comment_and_like — boolean
  • is_comm_artist_like — boolean
  • is_comm_artist_post — boolean
  • is_comm_new_post — boolean
  • is_event_alert — boolean
  • created_id — char(26)
  • updated_id — char(26)
  • deleted_id — char(26)
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean
  • deleted_at — timestamp

user_profile_type

  • id — char(26) — Foreign key → user.id — NOT NULL
  • type_name — VARCHAR(255)
  • created_id — char(26)
  • updated_id — char(26)
  • deleted_id — char(26)
  • created_at — timestamp
  • updated_at — timestamp
  • is_deleted — boolean
  • deleted_at — timestamp