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