mori

Tables (10)

base (감사로그)

  • is_deleted (삭제여부) — boolean
  • created_at (생성일) — datetime
  • created_by (생성한 사람) — bigint
  • updated_at (수정일) — datetime
  • updated_by (수정한 사람) — bigint
  • deleted_at (삭제일) — datetime
  • deleted_by (삭제한 사람) — bigint

m_answer (답변)

  • answer_id (답변 ID) — bigint — Primary key — NOT NULL
  • question_id (질문 ID) — bigint — Foreign key → m_question.question_id — NOT NULL
  • user_id (사용자 ID) — bigint — Foreign key → m_user.user_id — NOT NULL
  • question_content (질문 내용) — varchar
  • answer_content (답변 내용) — varchar
  • image_url (이미지 URL) — varchar(2048)

m_category (카테고리)

  • category_id (카테고리 ID) — bigint — Primary key — NOT NULL
  • name (카테고리 이름) — varchar

m_initial_question (초기 질문)

  • initial_question_id (초기 질문 ID) — bigint — Primary key — NOT NULL
  • category_id (카테고리 ID) — bigint — Foreign key → m_category.category_id — NOT NULL
  • content (질문 내용) — varchar

m_payment (결제)

  • payment_id (결제 ID) — bigint — Primary key — NOT NULL
  • user_id (사용자 ID) — bigint — Foreign key → m_user.user_id — NOT NULL
  • product_id (상품 ID) — bigint — Foreign key → m_product.product_id — NOT NULL
  • amount (금액) — int
  • credit_amount (충전된 크레딧 양) — int
  • payment_status (결제 상태) — enum
  • payment_type (결제 방식) — enum
  • trasaction_number (주문번호) — varchar
  • purchase_token (구매 토큰) — varchar(255)

m_product (상품)

  • product_id (상품 ID) — bigint — Primary key — NOT NULL
  • price (Field2) — int
  • name (상품 이름) — enum
  • product_status (판매 상태) — enum
  • google_product_id (구글 상품 ID) — enum

m_question (질문)

  • question_id (질문 ID) — bigint — Primary key — NOT NULL
  • user_id (사용자 ID) — bigint — Foreign key → m_user.user_id — NOT NULL
  • category_id (카테고리 ID) — bigint — Foreign key → m_category.category_id — NOT NULL
  • content (질문 내용) — varchar
  • question_type (질문 유형) — enum

m_report (리포트(신고))

  • report_id (신고 ID) — Primary key — NOT NULL
  • user_id (사용자 ID) — bigint — Foreign key → m_user.user_id — NOT NULL
  • reason (신고 사유)
  • report_type (신고 유형) — enum
  • answer_content (답변 내용 전체) — varchar

m_user (유저)

  • user_id (사용자 ID) — bigint — Primary key — NOT NULL
  • social_id (소셜 로그인 고유 식별 ID) — varchar
  • provider (소셜 로그인 제공자) — enum
  • email (이메일) — varchar
  • nickname (사용자명) — varchar
  • role (권한) — enum
  • child_name (아이 이름) — varchar
  • child_age_group (나이대) — enum
  • credit (크레딧) — int

m_user_category (유저_카테고리)

  • user_category_id (사용자 카테고리 ID) — Primary key — NOT NULL
  • user_id (사용자 ID) — bigint — Foreign key → m_user.user_id — NOT NULL
  • category_id (카테고리 ID) — bigint — Foreign key → m_category.category_id — NOT NULL