COLOR BLOSSOM

Tables (9)

SURVEY_RESULT (설문결과)

  • UID (ID) — Primary key — NOT NULL
  • BODY_RESULT (체형결과)
  • UID (설문자ID) — Foreign key → USER.UID — NOT NULL
  • Field (등록일자)
  • HEIGHT_RESULT (신장결과)

USER (회원)

  • UID (Key) — Primary key — NOT NULL
  • ID (아이디)
  • NAME (이름)
  • PASSWORD (비밀번호)
  • PHONE (전화번호)
  • REG_DATE (등록일자)
  • USE_YN (사용여부)
  • SEX (성별)

booking (예약)

  • uid (id) — Primary key — NOT NULL
  • resevation_number (예약자수)
  • resevation_time (예약일자)
  • deposit_YN (입금여부)
  • status (상태)
  • UID (Key) — Foreign key → USER.UID — NOT NULL
  • PAYMENT_TYPE (결제수단)
  • Field (결제금액)
  • Field2 (할인금액)
  • Field3 (최종결제금액)
  • reg_date (생성일자)
  • ADDITIONAL_MESSAGE (추가요청사항)

faq

  • uid (id) — Primary key — NOT NULL
  • question (질문)
  • answer (답변)
  • use_yn (사용여부)
  • priority (우선순위)

fee (요금표)

  • name (요금명)
  • fee (가격)
  • reg_date (등록일자)
  • update_date (변경일자)

language (언어)

  • uid (Key) — Primary key — NOT NULL
  • page (페이지)
  • section (표기될 영역)
  • sequence (순서)
  • content (내용)
  • language (언어)

ono_on_one (1대1)

  • uid (id) — Primary key — NOT NULL
  • question (질문)
  • answer (답변)
  • reg_date (등록일자)
  • update_date (변경일자)
  • UID (사용자 아이디) — Foreign key → USER.UID — NOT NULL

payment (결제)

  • uid (id) — Foreign key → booking.uid — NOT NULL
  • status (진행상태)
  • total_amount (결제금액)
  • created_at (결제생성일자)
  • updated_at (결제갱신일자)
  • Field (결제수단)
  • Field2

portone_payment (포트원 결제내역)

  • uid (id) — Primary key — NOT NULL
  • meta (포트원결제내역) — json
  • Field