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