cclime
Tables (22)
admin (관리자 테이블)
- admin_id (number) — Primary key — NOT NULL
- admin_identifier (Field)
- password (Field2)
- store_id (Field3)
- role (Field4)
- is_enable (Field5)
- created_at (Field6)
- updated_at (Field7)
answer (QnA 답변 테이블)
- answer_id (Key) — Primary key — NOT NULL
- answer_content (Field)
- admin_id (Field2)
- is_enable (Field3)
- created_at (Field4)
- Field5
beautyst (뷰티스트 테이블)
- beautyst_id (Key) — Primary key — NOT NULL
- beautyst_name (Field)
- store_id (Field2)
- beautyst_birth (Field3)
- position (Field4)
- beautyst_phone (Field5)
- beautyst_career (Field6)
- cclime_career (Field7)
- certificate (Field8)
- address (Field9)
- beautyst_img (Field10)
- note (Field11)
- is_enablec (Field12)
- created_at (Field13)
- updated_at (Field14)
category (카테고리)
- category_id (Key) — Primary key — NOT NULL
- category_title (Field)
- type (Field2)
- is_enable (Field3)
- created_at (Field4)
- Field5
comment (댓글 테이블)
- comment_id (Key) — Primary key — NOT NULL
- user_id (Field)
- comment_content (Field2)
- event_id (Field3)
- is_enable (Field4)
- created_at (Field5)
- updated_at (Field6)
event (이벤트 테이블)
- event_id (Key) — Primary key — NOT NULL
- event_start (Field)
- event_end (Field2)
- event_title (Field3)
- event_content (Field4)
- event_img (Field5)
- comment_enable (Field6)
- event_state (Field7)
- created_at (Field8)
- updated_at (Field9)
grade (등급테이블)
- grade_id (Key) — Primary key — NOT NULL
- grade_name (Field)
- Field2
like (좋아요 테이블)
- like_id (Key) — Primary key — NOT NULL
- user_id (Field)
- event_id (Field2)
- created_at (Field3)
mileage (적립금 테이블)
- mileage_id (Key) — Primary key — NOT NULL
- user_id (Field)
- mileage_amount (Field2)
- deleted_at (Field3)
- is_enable (Field4)
- created_at (Field5)
- Field6
notice (공지사항 테이블)
- notice_id (Key) — Primary key — NOT NULL
- notice_title (Field)
- notice_content (Field2)
- admin_ad (Field3)
- read_role (Field4)
- is_enable (Field5)
- created_at (Field6)
- updated_at (Field7)
prepaid (선불권 테이블)
- prepaid_id (Key) — Primary key — NOT NULL
- prepaid_title (Field)
- prepaid_amount (Field2)
- is_enable (Field3)
- created_at (Field4)
- is_use (Field5)
prepaid_program (선불권 in 프로그램 테이블)
- prepaid_program_id (Key) — Primary key — NOT NULL
- prepaid_id (Field)
- program_id (Field2)
- is_enable (Field3)
- created_at (Field4)
- is_use (Field5)
program (프로그램 테이블)
- program_id (Key) — Primary key — NOT NULL
- category_id (Field)
- program_ko (Field2)
- program_en (Field3)
- program_img (Field4)
- program_content (Field5)
- program_time (Field6)
- is_enable (Field7)
- created_at (Field8)
- updated_at (Field9)
- is_use (Field10)
program_amount (프로그램 가격 테이블)
- program_amount_id (Key) — Primary key — NOT NULL
- program_count (Field)
- program_price (Field2)
- program_id (Field3)
- discount_explanation (Field4)
- discount_price (Field5)
- is_enable (Field7)
- created_at (Field8)
- updated_at (Field9)
program_manage (프로그램 관리 테이블)
- program_manage_id (Key) — Primary key — NOT NULL
- program_id (Field)
- program_manage_seq (Field2)
- program_manage_content (Field3)
- is_enable (Field4)
- created_at (Field8)
- updated_at (Field9)
question (QnA 질문 테이블)
- question_id (Key) — Primary key — NOT NULL
- question_title (Field)
- question_content (Field2)
- admin_id (Field3)
- is_enable (Field4)
- created_at (Field5)
- Field6
reply (답글 테이블)
- reply_id (Key) — Primary key — NOT NULL
- admin_id (Field)
- reply_content (Field2)
- comment_id (Field3)
- is_enable (Field4)
- created_at (Field5)
- updated_at (Field6)
report (불편신고 테이블)
- report_id (Key) — Primary key — NOT NULL
- user_id (Field)
- store_id (Field2)
- temporarily (Field3)
- report_title (Field4)
- report_content (Field5)
- report_state (Field6)
- type (Field7)
- report_answer (Field8)
- is_enable (Field9)
- report_created_at (Field10)
- answer_created_at (Field11)
- updated_at (Field12)
reservation (예약 테이블)
- reservation_id (Key) — Primary key — NOT NULL
- user_id (Field)
- store_id (Field2)
- temporarily (Field3)
- beautyst_id (Field4)
- program_id (Field5)
- prepaid_id (Field7)
- state (Field6)
- created_at (Field8)
- updated_at (Field9)
store (지점 테이블)
- store_id (Key) — Primary key — NOT NULL
- store_name (Field)
- business_num (Field2)
- store_type (Field3)
- representative (Field4)
- tel (Field5)
- email (Field6)
- address (Field7)
- bed (Field8)
- parking (Field9)
- store_img (Field10)
- week_open (Field11)
- week_close (Field12)
- sat_open (Field13)
- sat_close (Field14)
- sun_open (Field15)
- sum_close (Field16)
- holiday_open (Field17)
- holiday_close (Field18)
- lunch_time (Field19)
- is_enable (Field20)
- created_at (Field21)
- updated_at (Field22)
store_customer (지점 고객 테이블)
- customer_id (Key) — Primary key — NOT NULL
- store_id (Field)
- user_id (Field2)
- isenable (Field3)
- created_at (Field4)
- updated_at (Field5)
user (고객(유저) 테이블)
- user_id (Key) — Primary key — NOT NULL
- email (Field)
- password (Field2)
- user_name (Field3)
- nick_name (Field4)
- birth (Field5)
- phone (Field6)
- grade_id (Field7)
- gender (Field8)
- address (Field9)
- skin (Field10)
- allergy (Field11)
- trouble (Field12)
- aesthetic (Field13)
- medicine (Field14)
- procedure (Field15)
- pregnancy (Field16)
- caution (Field17)
- cclime_route (Field18)
- marry (Field19)
- tel (Field20)
- wedding_day (Field21)
- route (Field22)
- is_enable (Field23)
- create_at (Field24)
- upload_at (Field25)