a

Tables (7)

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

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)
  • 관리자 id (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

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