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