CCLIME(NEW)

Tables (59)

Announcements (announcements)

  • annouce Id (annouce_id) — BIGINT — Primary key — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Title (title) — VARCHAR(200)
  • Description (decription) — TEXT
  • Photos (photos) — JSON
  • Views (views) — INT
  • Files (files) — JSON
  • On top (is_top) — BOOLEAN
  • Visibility (is_visibility) — BOOLEAN
  • Published date (published_date) — DATETIME
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL

Answers of survey (ans_f_survey)

  • Anw ID (anw_id) — BIGINT — Primary key — NOT NULL
  • Content (content) — TEXT
  • Ques type (type) — VARCHAR(50)
  • Ques ID (ques_id) — BIGINT — Foreign key → Questions of survey.Ques ID — NOT NULL

Bed (bed)

  • Bed id (id) — BIGINT — Primary key — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Bed name (name) — VARCHAR(255) — NOT NULL
  • Bed enabled (id_enabled) — BOOLEAN — NOT NULL
  • Bed order (order) — INT

Bookmarks (bookmarks)

  • Bookmark Id (bmark_id) — BIGINT — Primary key — NOT NULL
  • Item name (item_name) — VARCHAR(255)
  • Count (count) — INT
  • Price (price) — BIGINT
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL

Categories (categories)

  • Category Id (cate_id) — UUID — Primary key — NOT NULL
  • Category name (cate_name) — VARCHAR(255) — Signature, Special, Body, Men's
  • Description (description) — TEXT
  • Thumbnail (thumb) — VARCHAR(255)
  • Number of products (num_prods) — INT
  • Parent category Id (parent_cate_id) — UUID — Foreign key → Categories.Category Id — NOT NULL

Clime Pay (clime_pay)

  • Key — Primary key — NOT NULL
  • Field

Comments Of Helpdesk (cmts_f_helpdesk)

  • Helpdesk Id (cmt_helpdesk_id) — BIGINT — Primary key — NOT NULL
  • Helpdesk Id (helpdesk_id) — BIGINT — Foreign key → Helpdesks.Helpdesk Id — NOT NULL
  • Body (body) — TEXT
  • Location (location) — VARCHAR(200)
  • Files (files) — JSON
  • User Id (users_id) — UUID — Foreign key → Helpdesks.User Id — NOT NULL

Coupon customer (coupon_customer)

  • Coupon id (id) — BIGINT — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Coupon Id (coupon_id) — UUID — Foreign key → Coupons.Coupon Id — NOT NULL
  • Coupon name (coupon_name) — varchar(255)
  • Period start (period_start) — timestamp — NOT NULL
  • Period end (period_end) — timestamp — NOT NULL
  • Used at (used_at) — timestamp

Coupons (coupons)

  • Coupon Id (coupon_id) — UUID — Primary key — NOT NULL
  • Product Id (product_id) — UUID — Foreign key → Products.Product Id — NOT NULL
  • Vip pass Id (vpass_id) — BIGINT — Foreign key → Vip Passes.Vip pass Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Vip Passes.Programe Id — NOT NULL
  • Code (code) — VARCHAR(255)
  • Thumbnail (thumb) — JSON
  • Discount percentage (discount_rate) — DECIMAL(5,2)
  • Quantity (quantity) — INT
  • Connected products (conn_prods) — JSON — the product that moves when you tap the Go to Use coupon
  • Description (desc) — TEXT
  • Promotion Area (is_top_fixed) — BOOLEAN
  • Start date (period_start) — DATETIME
  • End date (period_end) — DATETIME
  • Connect type (connected_type) — VARCHAR(255) — enum: ALL,PROGRAM,FREE_PASS,PRODUCT

Coupons of customer (coupons_customer)

  • Customer coupon Id (cus_coupon_id) — BIGINT — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Coupon Id (coupon_id) — UUID — Foreign key → Coupons.Coupon Id — NOT NULL
  • Code (code) — VARCHAR(255)
  • Discount Amount (discount) — BIGINT
  • Expiration date (expire_date) — DATETIME
  • Used (is_used) — BOOLEAN
  • Discount percentage (discount_percent) — DECIMAL(5,2)
  • User Id (users_id) — UUID — Foreign key — NOT NULL
  • Product Id (product_id) — UUID — Foreign key → Coupons.Product Id — NOT NULL
  • Vip pass Id (vpass_id) — BIGINT — Foreign key → Coupons.Vip pass Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Coupons.Programe Id — NOT NULL

Customer Event Notification (customer_event_notification)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Event Id (event_id) — BIGINT — Foreign key → Events.Event Id — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Sender user (sender_user_id) — UUID — Foreign key → Users (implemented).User Id — NOT NULL
  • isSendPush — BOOLEAN
  • Customer name (customer_name) — VARCHAR(255)
  • Customer phonec (customer_phone) — VARCHAR(255)
  • Customer email (customer_email) — VARCHAR(255)
  • Sender username (sender_username) — VARCHAR(255)
  • Event name (event_name) — VARCHAR(255)

Customer Histories (customer_histories)

  • Customer History Id (cus_his_id) — BIGINT — Primary key — NOT NULL
  • Reservation Id (reservertion_id) — UUID — Foreign key → Reservations.Reservation Id — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Total sales (total_sales) — BIGINT
  • Last visit date (last_visit_date) — DATE
  • Last location (last_location) — VARCHAR(255)
  • Recent treatment (recent_treatment) — VARCHAR(255)
  • Last store (last_store) — VARCHAR(255) — Jeonjeom, Gangnam-gu Office, Gangnam Headquarters, Gwangju, Gimhae, Daedongseongro, Daejeongwanjeo, Daejeon City Hall,…
  • User Id (users_id) — UUID — Foreign key — NOT NULL
  • User Id (users_id2) — UUID — Foreign key — NOT NULL
  • Bed id (id22) — BIGINT — Foreign key → Reservations.Bed id — NOT NULL

Customer Memories (customer_memories)

  • Customer mem Id (cus_memo_id) — BIGINT — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Attribute name (attr_name) — VARCHAR(255)
  • Attribute value (attr_value) — VARCHAR(255)
  • Photos (photos) — JSON
  • Notes (notes) — TEXT

Customer SMS (customer_sms)

  • Customer SMS id (id) — BIGINT — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • SMS id (sms_id) — BIGINT — Foreign key → SMS.SMS id — NOT NULL
  • Sender user id (sender_user_id) — UUID — Foreign key → SMS.Sender user id — NOT NULL
  • Phone number (phone_number) — VARCHAR(255) — NOT NULL
  • Is sent (is_sent) — TINYINT — NOT NULL

Customers (implemented) (customers)

  • Customer Id (customer_id) — UUID — Primary key — NOT NULL
  • User Id (users_id) — UUID — Foreign key → Users (implemented).User Id — NOT NULL
  • Barcode (barcode) — VARCHAR(255)
  • FullName (full_name) — VARCHAR(100)
  • Gender (gender) — ENUM('Male', 'Female')
  • Date of birth (date_of_birth) — DATE
  • Nation (nation) — VARCHAR(100)
  • Membership points (mem_points) — INT
  • Survey result (survey_result) — TEXT
  • Source (source) — VARCHAR(255) — Acquaintance recommendation, Instagram, Naver/Blog, YouTube, Homepage, Facebook
  • Number of visit (num_visit) — INT
  • Number of VIP passes (num_vip_passes) — INT
  • Rating (rating) — ENUM — Basic, Gold, Platinum, Emerald, Sapphire, Diamond
  • Avatar (avatar_url) — JSON
  • Have siblings (is_have_siblings) — BOOLEAN
  • Status (status) — VARCHAR(50)
  • Email (email) — VARCHAR(200)
  • Notes (notes) — JSON

Events (events)

  • Event Id (event_id) — BIGINT — Primary key — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Event name (name) — VARCHAR(255)
  • Description (description) — TEXT
  • Event Type (event_type) — VARCHAR(100)
  • Location (location) — VARCHAR(100)
  • Max partipations (max_participants) — INT
  • Current participants (curr_participants) — INT
  • Status (status) — VARCHAR(50)
  • Start time (start_time) — DATETIME
  • End time (end_time) — DATETIME
  • Photos (photos) — JSON
  • Event Banner Photo (banner) — JSON
  • Product Id (product_id) — UUID — Foreign key → Products.Product Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Programes.Programe Id — NOT NULL
  • Vip pass Id (vpass_id) — BIGINT(20) — Foreign key → Vip Passes.Vip pass Id — NOT NULL
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL
  • Product Id (product_id2) — UUID — Foreign key → Products.Product Id — NOT NULL
  • Vip pass Id (vpass_id2) — BIGINT — Foreign key → Products.Vip pass Id — NOT NULL
  • Programe Id (programe_id2) — UUID — Foreign key → Vip Passes.Programe Id — NOT NULL

Helpdesks (helpdesks)

  • Helpdesk Id (helpdesk_id) — BIGINT — Primary key — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Title (title) — VARCHAR(255)
  • Body (body) — TEXT
  • Location (location) — VARCHAR(200)
  • Count comments (count_cmts) — INT
  • Files (files) — JSON
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL

Membership points (mem_points)

  • Membership point Id (mem_point_id) — BIGINT — Primary key — NOT NULL
  • Membership points (mem_points) — INT
  • Membership points deducted (deduct_mem_points) — INT
  • Expiration date (expire_date) — DATE
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL

Notifications (notifications)

  • Notification Id (notice_id) — BIGINT(20) — Primary key — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Readed (is_readed) — BOOLEAN
  • Sent at (sent_at) — DATETIME
  • Title (title) — VARCHAR(255)
  • Content (content) — TEXT
  • Thumbnail (thumb) — JSON
  • Type (type) — VARCHAR(255) — Program/All-Day Pass Expiration,Event, Coupon
  • Start date (start_date) — DATETIME
  • Send all users (is_all) — BOOLEAN
  • Send now (is_now) — BOOLEAN
  • Receiver (receiver) — VARCHAR(255)
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL

Notifications of customer (noti_f_cus)

  • Notification Id (cus_notice_id) — BIGINT — Primary key — NOT NULL
  • Title (title) — VARCHAR(255)
  • Content (content) — TEXT
  • Message (message) — TEXT
  • Readed (is_readed) — BOOLEAN
  • Sent at (sent_at) — DATETIME
  • Thumbnail (thumb) — JSON
  • Type (type) — VARCHAR(255) — Program/All-Day Pass Expiration,Event, Coupon
  • Start date (start_date) — DATETIME
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL

OTP Verifications (opt_verifications)

  • OTP id (opt_id) — BIGINT — Primary key — NOT NULL
  • OTP code (otp_code) — VARCHAR(20)
  • Phone number (phone_number) — VARCHAR(20)
  • Used (is_used) — BOOLEAN
  • User Id (users_id) — UUID — Foreign key → Users (implemented).User Id — NOT NULL

Order details (order_details)

  • Id (order_details_id) — BIGINT — Primary key — NOT NULL
  • Quantity (quantity) — INT
  • Unit price (unit_price) — BIGINT
  • Total price (total_price) — BIGINT
  • Product name (prod_name) — VARCHAR(255)
  • OrderId (order_id) — IUUID — Foreign key → Orders.OrderId — NOT NULL
  • Product Id (product_id) — UUID — Foreign key → Products.Product Id — NOT NULL
  • User Id (users_id) — UUID — Foreign key → Products.User Id — NOT NULL
  • Product Id (product_id2) — UUID — Foreign key → Products.Product Id — NOT NULL
  • Vip pass Id (vpass_id) — BIGINT — Foreign key → Products.Vip pass Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Products.Programe Id — NOT NULL

Orders (orders)

  • OrderId (order_id) — UUID — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Order date (order_date) — DATETIME
  • Order amount (order_amount) — INT
  • Discount amount (discount_amount) — BIGINT
  • Status (status) — ENUM — 'Incomplete', 'Complete', 'Shipping', 'Unship'
  • Payment (is_payment) — BOOLEAN
  • Address (address) — VARCHAR(255)
  • Payment method (pay_method) — VARCHAR(255)
  • Tax (tax) — DECIMAL(5,2)
  • Shipping cost (ship_cost) — BIGINT
  • Refunded (is_refunded) — BOOLEAN
  • Notes (notes) — TEXT
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL

PaymentHistory (payment_history)

  • PaymentId (payment_Id) — UUID — Primary key — NOT NULL
  • OrderId (order_id) — UUID — Foreign key → Orders.OrderId — NOT NULL
  • TransactionId (tid) — VARCHAR(255)
  • ResultMsg (result_msg) — TEXT
  • PayMethod (pay_method) — VARCHAR(10)
  • EdiDate (edi_date) — DATETIME
  • GoodsAmount (goods_amt) — INT
  • SignData (sign_data) — VARCHAR(255)

Performances of Staff (performs_f_staff)

  • Perfom of staff (perfom_f_staff_id) — BIGINT — Primary key — NOT NULL
  • Increased percentage (incre_percent) — DECIMAL(5,2)
  • Total sales (total_sales) — BIGINT
  • Total deduction (total_deduction) — BIGINT
  • Total products (total_products) — BIGINT
  • Number of treatments (num_treatments) — INT
  • Number of reservations (num_reserve) — INT
  • Number of VIP passes (num_vip_passes) — INT
  • Record date (record_date) — DATE
  • Day (day) — INT
  • Month (month) — VARCHAR(50)
  • Year (year) — INT
  • Staff Id (staff_id2) — UUID — Foreign key → Staffs (Staff = Employee).Staff Id — NOT NULL
  • User Id (users_id2) — UUID — Foreign key — NOT NULL

Performances of customer (performs_f_customer)

  • Perform of customer (perfom_f_cus_id) — BIGINT — Primary key — NOT NULL
  • Total sales (total_sales) — BIGINT — Total sales + cash + card + bank transfer + receivables + program usage
  • Total deductions (total_deductions) — BIGINT
  • Total products (total_products) — BIGINT
  • Total treatments (total_treatments) — BIGINT
  • Total others (total_others) — BIGINT
  • Number of VIP passes (num_vip_passes) — INT
  • Number of treatments (num_treatments) — INT
  • Number of reservations (num_reserve) — INT
  • Increased percentage (incre_percent) — DECIMAL(5, 2)
  • Record date (record_date) — DATE
  • Day (day) — INT
  • Month (month) — INT
  • Year (year) — INT
  • Total by cash (total_by_cash) — BIGINT
  • Total by card (total_by_card) — BIGINT
  • Total by bank (total_by_bank) — BIGINT
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL

Performances of store (performs_f_store)

  • Id (perfom_f_store_id) — BIGINT — Primary key — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Total sales (total_sales) — BIGINT
  • Total deductions (total_deductions) — BIGINT
  • Total products (total_products) — BIGINT
  • Number of VIP passes (num_vip_passes) — INT
  • Number of treatments (num_treatments) — INT
  • Number of reservations (num_reserve) — INT
  • Increased percentage (incre_percent) — DECIMAL(5, 2)
  • Record date (record_date) — DATE
  • Day (day) — INT
  • Month (month) — VARCHAR(50)
  • Year (year) — INT
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL

Procedure Evaluation Histories (proce_eva_his)

  • Proce Eva His Id (proc_eva_his_id) — BIGINT — Primary key — NOT NULL
  • Treatment name (treat_name) — VARCHAR(255)
  • Treatment category (treat_cate) — VARCHAR(255)
  • Programe name (prog_name) — VARCHAR(255)
  • Management ticket (manage_ticket) — VARCHAR(255)
  • Store name (store_name) — VARCHAR(255)
  • Staff name (staff_name) — VARCHAR(255)
  • Star rating (star_rating) — INT
  • Notes (notes) — TEXT
  • Customer name (cus_name) — VARCHAR(255)
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Staff Id (staff_id) — UUID — Foreign key → Staffs (Staff = Employee).Staff Id — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL

Product histories rank (product_his_rank)

  • Product history rank Id (prod_his_rank_id) — BIGINT — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Last date (last_date) — DATE
  • Product name (product_name) — VARCHAR(255)
  • Count products (count_products) — INT
  • Mobile purchases (mobile_purchases) — INT
  • Store purchases (store_purchases) — INT

Production reviews (prod_reviews)

  • Prod review Id (prod_rev_id) — BIGINT — Primary key — NOT NULL
  • Rating (rating) — INT
  • Comment (cmt) — TEXT
  • Product Id (product_id) — UUID — Foreign key → Products.Product Id — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Visibility (is_visibility) — BOOLEAN
  • User Id (users_id) — UUID — Foreign key → Products.User Id — NOT NULL
  • Product Id (product_id2) — UUID — Foreign key → Products.Product Id — NOT NULL
  • Vip pass Id (vpass_id) — BIGINT — Foreign key → Products.Vip pass Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Products.Programe Id — NOT NULL

Products (products)

  • Product Id (product_id) — UUID — Primary key — NOT NULL
  • Category Id (cate_id) — UUID — Foreign key → Categories.Category Id — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Category name (cate_name) — VARCHAR(255) — Signature, Special, Body, Men's
  • Product name (prod_name) — VARCHAR(255)
  • Price (price) — BIGINT
  • Stock quantity (quantity) — INT
  • Homecare available (is_homecare) — BOOLEAN
  • Warehouse date (warehouse_date) — DATETIME
  • Initial cost (init_cost) — BIGINT(20)
  • Thumbnail (thumb) — JSON
  • Description (desc) — TEXT
  • Primary classification (prim_class) — VARCHAR(255)
  • Secondary classification (sec_class) — VARCHAR(255)
  • Interruption Photos (interup_photos) — JSON
  • Review points (review_points) — BIGINT
  • Percentage per purchase (percent_per_pur) — DECIMAL(5,2)
  • Summary photos (summ_photos) — JSON
  • Coupon Id (coupon_id) — UUID — Foreign key → Coupons.Coupon Id — NOT NULL
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL
  • Product Id (product_id2) — UUID — Foreign key → Coupons.Product Id — NOT NULL
  • Vip pass Id (vpass_id) — BIGINT — Foreign key → Coupons.Vip pass Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Coupons.Programe Id — NOT NULL

Programes (programes)

  • Programe Id (programe_id) — UUID — Primary key — NOT NULL
  • Programe name (prog_name) — VARCHAR(255) — Signature, Special, body, male
  • Description (description) — TEXT
  • Stopped (is_stopped) — BOOLEAN
  • Category (category_name) — VARCHAR(255) — Signature, Event, Special, Body, Men's
  • Thumbnail (thumb_url) — VARCHAR(255)
  • Keywords (keywords) — VARCHAR(255)
  • Administrative time (admin_time) — TIME
  • Interruption Photos (interup_photos) — JSON
  • percentage of points earned per purchase (percent_per_pur) — DECIMAL(5,2)
  • Points per review (review_points) — BIGINT
  • Price (price) — BIGINT
  • Category Id (cate_id) — UUID — Foreign key → Categories.Category Id — NOT NULL
  • User Id (users_id) — UUID — NOT NULL

Questions of survey (ques_f_survey)

  • Ques ID (ques_id) — BIGINT — Primary key — NOT NULL
  • Content (content) — TEXT
  • Ques type (type) — VARCHAR(50)
  • Survey Id (survey_id) — BIGINT — Foreign key → Surveys.Survey Id — NOT NULL

Relatives of customer (relatives_f_cus)

  • Relative Id (relative_id) — BIGINT — Primary key — NOT NULL
  • Relative name (relative_name) — VARCHAR(255)
  • Date of birth (date_of_birth) — DATE
  • Phone number (phone_number) — VARCHAR(20)
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL

Reservation Classifications (Will be deleted) (reserve_class)

  • Reserve class Id (reserve_class_id) — BIGINT — Primary key — NOT NULL
  • Class name (class_name) — VARCHAR(255)
  • Reservation Id (reservertion_id) — UUID — Foreign key → Reservations.Reservation Id — NOT NULL
  • User Id (users_id) — UUID — Foreign key — NOT NULL
  • User Id (users_id2) — UUID — Foreign key — NOT NULL
  • Bed id (id22) — BIGINT — Foreign key → Reservations.Bed id — NOT NULL

Reservation Program (reservation_program)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Program Id (programe_id) — UUID — Foreign key → Programes.Programe Id — NOT NULL
  • Reservation Id (reservertion_id) — UUID — Foreign key → Reservations.Reservation Id — NOT NULL

Reservation Staff (reservation_staff)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Reservation Id (reservertion_id) — UUID — Foreign key → Reservations.Reservation Id — NOT NULL
  • Staff Id (staff_id) — UUID — Foreign key → Staffs (Staff = Employee).Staff Id — NOT NULL
  • Start time (start_time) — TIME
  • End time (end_time) — TIME

Reservations (reservations)

  • Reservation Id (reservertion_id) — UUID — Primary key — NOT NULL
  • Bed id (bed_id) — BIGINT — Foreign key → Bed.Bed id — NOT NULL
  • Meet date (meet_date) — DATE
  • Start time (start_time) — TIME
  • End time (end_time) — TIME
  • Duration minutes (durations_minutes) — INT
  • Status (status) — ENUM — Confirmed, Cancelled, Pending
  • Customer notes (cus_notes) — TEXT
  • Employee notes (employee _notes) — TEXT
  • Cancel notes (cancel_notes) — TEXT
  • Reminder sent (is_reminded) — BOOLEAN
  • Parking (is_parking) — BOOLEAN
  • Reserve method (reserve_method) — VARCHAR(100) — Mobile/On-site
  • Customer name (cus_name) — VARCHAR(255)
  • Customer phone number (cus_phone) — VARCHAR(20)
  • Private Room (is_private_room) — BOOLEAN
  • Number of beds (num_beds) — INT
  • Number of lights (num_lights) — INT
  • Classification (classification) — ENUM — 'New', 'Branch', 'Influencer'
  • Male (is_male) — BOOLEAN
  • Refresh minutes (refresh_minnutes) — INT
  • Setup name (setup_name) — VARCHAR(255)
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL

SMS (sms)

  • SMS id (id) — BIGINT — Primary key — NOT NULL
  • Sender user id (sender_user_id) — UUID — Foreign key → Users (implemented).User Id — NOT NULL
  • Content (content) — TEXT
  • Scheduled at (schedule_at) — TIMESTAMP — null = send immediatedly
  • Is sent (is_sent) — TINYINT
  • Receiver role (receiver_role) — VARCHAR(255) — CUSTOMER, EMPLOYEE

Staff Prohibition (Employee prohibition) (staff_prohibition)

  • Id (sche_f_staff_id) — BIGINT — Primary key — NOT NULL
  • work date (work_date) — DATE
  • Is all day (is_all_day) — BOOLEAN
  • Start time (start_time) — TIME
  • End time (end_time) — TIME
  • Work type (work_type) — ENUM
  • Notes (note) — TEXT
  • Staff Id (staff_id) — UUID — Foreign key → Staffs (Staff = Employee).Staff Id — NOT NULL
  • Status (status) — VARCHAR(50) — Work, Meals, Vacations, Education, Early Departure, Hospital Absences, Outings, Meetings

Staffs (Staff = Employee) (staffs)

  • Staff Id (staff_id) — UUID — Primary key — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Fullname (full_name) — VARCHAR(100)
  • Gender (gender) — ENUM('Male', 'Female')
  • Date of birth (date_of_birth) — DATE
  • Position (positions) — ENUM('Beauty_manager', 'Beauticist')
  • Salary (salary) — BIGINT
  • Hired date (hired_date) — DATE
  • Perfomance score (performance_score) — INT
  • Status (status) — ENUM — Closed/Work
  • Rank (rank) — VARCHAR(255)
  • Off (is_off) — BOOLEAN
  • Avatar (avatar_url) — JSON
  • Belt area (belt) — ENUM — White, Yellow, Green, Purple, Blue, Red, Black, Silver, Gold
  • Programe (programe) — ENUM — Basic, Body, Face, Skin
  • Notes (notes) — TEXT
  • Output selection (output_selection) — ENUM — Sales/Branch Sales/Mobile Reservation/Reservation
  • Sheet URL (sheet_url) — VARCHAR(255)

Stores (Implemented) (stores)

  • Store Id (store_id) — UUID — Primary key — NOT NULL
  • User Id (user_id) — UUID — Foreign key → Users (implemented).User Id — NOT NULL
  • Store name (name) — VARCHAR(255)
  • Location (location) — VARCHAR(255)
  • Phone number (phone_number) — VARCHAR(20)
  • Head office (is_head_office) — BOOLEAN
  • Stopped (is_stopped) — BOLEAN
  • Description (description) — TEXT
  • Total sales (total_sales) — BIGINT
  • Total VIP passes (total_vip_passes) — BIGINT
  • Total products (total_products) — BIGINT
  • Work start time (work_start_time) — TIME
  • Work end time (work_end_time) — TIME
  • Break start time (break_start_time) — TIME
  • Break end time (break_end_time) — TIME

Surveys (surveys)

  • Survey Id (survey_id) — BIGINT — Primary key — NOT NULL
  • Title (title) — VARCHAR(255)
  • Description (description) — TEXT
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL

Treatment Program (treatment_program)

  • ID (id) — BIGINT — Primary key — NOT NULL
  • Treatment Id (treatm_id) — UUID — Foreign key → Treatments.Treatment Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Programes.Programe Id — NOT NULL

Treatment histories (treatment_his)

  • Treatment History Id (treat_his_id) — BIGINT — Primary key — NOT NULL
  • Duration minutes (duration_minutes) — INT
  • Intensity (intensity) — VARCHAR(255)
  • Focus area (focus_area) — VARCHAR(255)
  • Photos (photos) — JSON
  • cumulative number of treatment sessions (num_sessions) — INT
  • Menu (menu) — VARCHAR(255)
  • Payment method (pay_method) — VARCHAR(50) — free pass/payment
  • Price (price) — BIGINT
  • Options (options) — TEXT
  • Treatment Id (treatm_id) — BIGINT — Foreign key → Treatments.Treatment Id — NOT NULL
  • Staff Id (staff_id) — UUID — Foreign key → Staffs (Staff = Employee).Staff Id — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Refunded (is_refunded) — BOOLEAN
  • Total price (total_price) — BIGINT
  • Discount (discount) — BIGINT
  • Notes (notes) — TEXT
  • Number of staffs (num_staffs) — INT
  • Total current sessions (total_curr_sessions) — INT
  • Expiration date (expire_date) — DATE
  • Programe name (prog_name) — VARCHAR(255)
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL
  • User Id (users_id2) — UUID — Foreign key → Treatments.User Id — NOT NULL
  • Reservation Id (reservertion_id) — UUID — Foreign key → Treatments.Reservation Id — NOT NULL

Treatment histories rank (treat_his_rank)

  • Treat history rank Id (treat_his_rank_id) — BIGINT — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Treatment name (treat_name) — VARCHAR(255)
  • Last date (last_date) — DATE
  • Count treatments (count_treatments) — INT
  • Mobile purchases (mobile_purchases) — INT
  • Store purchases (store_purchases) — INT

Treatments (treatments)

  • Treatment Id (treatm_id) — UUID — Primary key — NOT NULL
  • User Id (users_id) — UUID — Primary key — NOT NULL
  • Reservation Id (reservertion_id) — UUID — Foreign key → Reservations.Reservation Id — NOT NULL
  • Treatment name (treat_name) — VARCHAR(255)
  • Description (description) — TEXT
  • Price (price) — BIGINT
  • Photo list (photo_list) — JSON
  • Is VIP pass (is_vip_pass_used) — BOOLEAN
  • Is sale entered (is_entered_sales) — BOOLEAN

Users (implemented) (users)

  • User Id (users_id) — UUID — Primary key — NOT NULL
  • Fcm token (fcm_token) — VARCHAR(255)
  • Username (username) — UNIQUE
  • Password (password) — VARCHAR(60)
  • Email (email) — VARCHAR(100)
  • Roles (roles) — ENUM — ADMIN,STORE,CUSTOMER
  • Phone number (phone_number) — VARCHAR(20)
  • Account status (account_status) — ENUM
  • Last login (last_login) — DATETIME
  • Join date (join_date) — DATETIME
  • Avatar url (avatar_url) — VARCHAR(200)
  • IP Address — VARCHAR(200)
  • Version — VARCHAR(200)

Vip Passes (vip_passes)

  • Vip pass Id (vpass_id) — BIGINT — Primary key — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Programes.Programe Id — NOT NULL
  • Store Id (store_id) — UUID — Foreign key → Stores (Implemented).Store Id — NOT NULL
  • Thumbnail (thumb) — JSON
  • VP name (vp_name) — VARCHAR(255)
  • Category (category) — VARCHAR(100)
  • Expiration date (expire_date) — DATETIME
  • Balance (balance) — BIGINT
  • Number of used (num_used) — INT
  • Limit (is_limit) — BOOLEAN
  • Is purchase (is_purchase) — BOOLEAN
  • Price (price) — BIGINT
  • Percentage of points (percent_points) — DECIMAL(5,2)
  • Top description (top_desc) — TEXT
  • Bottome description (bot_desc) — TEXT
  • Free Pass charge amount (fluid) — BIGINT
  • User Id (users_id) — UUID — Foreign key → Stores (Implemented).User Id — NOT NULL

Vip Passes of customer (vip_passes_customer)

  • Customer VIP pass Id (cus_vpass_cus_id) — UUID — Primary key — NOT NULL
  • Vip pass Id (vpass_id) — BIGINT — Foreign key → Vip Passes.Vip pass Id — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Total used (total_used) — BIGINT
  • Total charges (total_charges) — BIGINT
  • VP name (vp_name) — VARCHAR(255)
  • Category (category) — VARCHAR(100)
  • Expiration date (expire_date) — DATETIME
  • Balance (balance) — BIGINT(20)
  • Number of used (num_used) — INT
  • Number of recharges (num_recharges) — INT
  • Purchased store (purchased_store) — VARCHAR(255)
  • Payment method (pay_method) — VARCHAR(100) — Cash, card, account, receivable, and ClimePay (mobile)
  • Status (status) — VARCHAR(50)
  • Limit (is_limit) — BOOLEAN
  • User Id (users_id) — UUID — Foreign key → Vip Passes.User Id — NOT NULL
  • Programe Id (programe_id) — UUID — Foreign key → Vip Passes.Programe Id — NOT NULL

customer_product

  • Key (id) — Primary key — NOT NULL
  • Key (purchase_log_id) — Foreign key → product_purchase_log.Key — NOT NULL
  • Customer Id (customer_id2) — UUID — Foreign key → product_purchase_log.Customer Id — NOT NULL
  • quantity — INT
  • purchase_date — TIMESTAMP
  • memo — TEXT
  • product_id — INT — NOT NULL
  • customer_id — INT — NOT NULL
  • order_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

customer_program

  • Key (id) — Primary key — NOT NULL
  • Key (purchase_log_id) — Foreign key → program_purchase_log.Key — NOT NULL
  • Customer Id (customer_id2) — UUID — Foreign key → program_purchase_log.Customer Id — NOT NULL
  • remaining_programs — INT
  • num_of_sessions — INT
  • start_at — TIMESTAMP
  • expired_at — TIMESTAMP
  • usage_type — VARCHAR(255)
  • is_refunded — BOOLEAN
  • program_id — INT — NOT NULL
  • customer_id — INT
  • order_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

customer_vip_pass

  • Key (id) — Primary key — NOT NULL
  • Key (purchase_log_id) — Foreign key → vip_pass_purchase_log.ID — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → vip_pass_purchase_log.Customer Id — NOT NULL
  • apply_scope — VARCHAR(255)
  • charge_amount — DECIMAL(15,2)
  • balance_amount — DECIMAL(15,2)
  • period_type — VARCHAR(255)
  • period_start — TIMESTAMP
  • period_end — TIMESTAMP
  • is_refunded — BOOLEAN
  • vip_pass_id — INT
  • order_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

product_purchase_log

  • Key (id) — Primary key — NOT NULL
  • Customer Id (customer_id2) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • type — VARCHAR(255) — REFUND,SALE
  • date — TIMESTAMP — NOT NULL
  • is_purchase_on_admin — BOOLEAN
  • product_id — INT — NOT NULL
  • quantity — INT — NOT NULL
  • amount — DECIMAL(15,2) — NOT NULL
  • vip_pass_amount — DECIMAL(15,2)
  • points_earned — INT
  • points_used — INT
  • payment_amount — DECIMAL(15,2)
  • cash_paid_amount — DECIMAL(15,2)
  • card_paid_amount — DECIMAL(15,2)
  • account_paid_amount — DECIMAL(15,2)
  • unpaid_amount — DECIMAL(15,2)
  • klime_pay_amount — DECIMAL(15,2)
  • is_cash_receipt — BOOLEAN
  • is_account_receipt — BOOLEAN
  • memo — TEXT
  • contributions — JSON
  • coupon_id — INT
  • customer_product_id — INT
  • refund_customer_product_id — INT
  • store_id — INT
  • customer_id — INT — NOT NULL
  • product_id_ref — INT — NOT NULL
  • is_refund_completed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

program_purchase_log

  • Key (id) — Primary key — NOT NULL
  • Customer Id (customer_id2) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • type — VARCHAR(255) — REFUND,SALE
  • is_purchased_on_admin — BOOLEAN
  • quantity — INT
  • amount — INT
  • payment_amount — DECIMAL(15,2)
  • cash_paid_amount — DECIMAL(15,2)
  • card_paid_amount — DECIMAL(15,2)
  • account_paid_amount — DECIMAL(15,2)
  • unpaid_amount — DECIMAL(15,2)
  • klime_pay_amount — DECIMAL(15,2)
  • points_earned — INT
  • points_used — INT
  • is_cash_receipt — BOOLEAN
  • is_account_receipt — BOOLEAN
  • date — TIMESTAMP — NOT NULL
  • memo — TEXT
  • customer_id — INT — NOT NULL
  • program_id — INT — NOT NULL
  • coupon_id — INT
  • customer_program_id — INT
  • refund_customer_program_id — INT
  • store_id — INT
  • start_at — TIMESTAMP
  • expired_at — TIMESTAMP
  • unit_price — INT
  • card_type — VARCHAR(255)
  • contributions — JSON
  • is_refund_completed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP

purchase_log

  • id — INT — Primary key
  • transaction_id — INT — NOT NULL
  • transaction_type — ENUM('PRODUCT_PURCHASE', 'PROGRAM_PURCHASE', 'VIP_PASS_PURCHASE', 'TREATMENT_DEDUCTION') — NOT NULL
  • transaction_date — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • customer_id — INT — NOT NULL
  • store_id — INT
  • employee_id — INT
  • item_id — INT — NOT NULL — Product ID, Program ID, VIP Pass ID, or Treatment ID
  • item_name — VARCHAR(255) — NOT NULL — Product name, Program name, VIP Pass name, or Treatment name
  • item_category — VARCHAR(255) — Category name if applicable
  • quantity — INT — NOT NULL
  • total_amount — DECIMAL(15, 2) — NOT NULL — Total transaction amount
  • payment_amount — DECIMAL(15, 2) — Actual payment received
  • vip_pass_amount — DECIMAL(15, 2) — Amount covered by VIP pass
  • program_amount — DECIMAL(15, 2) — Amount covered by program
  • unpaid_amount — DECIMAL(15, 2) — Remaining unpaid amount
  • cash_paid_amount — DECIMAL(15, 2)
  • card_paid_amount — DECIMAL(15, 2)
  • account_paid_amount — DECIMAL(15, 2)
  • klime_pay_amount — DECIMAL(15, 2)
  • points_used — INT
  • points_earned — INT
  • is_refund — BOOLEAN
  • refund_reference_id — INT — ID of the original transaction being refunded
  • source_entity — VARCHAR(255) — NOT NULL — Source entity table name
  • transaction_status — VARCHAR(50)
  • memo — TEXT
  • employee_contributions — JSON — Employee contribution percentages
  • additional_data — JSON — Any additional data specific to transaction type
  • (treatment_deduction_id) — Foreign key → treatment_deduction.Key — NOT NULL — For vip pass treatment
  • (program_purchase_log_id) — Foreign key → program_purchase_log.Key — NOT NULL
  • (vip_pass_purchase_log_id) — Foreign key → vip_pass_purchase_log.ID — NOT NULL
  • (product_purchase_log_id) — UUID — Foreign key → product_purchase_log.Customer Id — NOT NULL

surveys1

  • survey_id — BIGINT — NOT NULL
  • users_id — UUID — NOT NULL
  • description_relative — TEXT — NOT NULL
  • skin — _problem`
  • aesthetic — _experience`
  • surgical_experience — BOOL
  • pregnant — BOOL
  • use_drugs — BOOL
  • description_health — BOOL
  • info_about — BOOL
  • relative_name — TEXT
  • care_service_name — TEXT
  • skin_type_name — TEXT

treatment_deduction

  • Key (id) — Primary key — NOT NULL
  • Customer Id (customer_id) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • Key (customer_program_id) — Foreign key → customer_program.Key — NOT NULL — For program treatment
  • Key (customer_vip_pass_id) — Foreign key → customer_vip_pass.Key — NOT NULL — For vip pass treatment
  • type — VARCHAR(255) — NOT NULL
  • date — TIMESTAMP — NOT NULL
  • quantity — INT — NOT NULL
  • total_amount — DECIMAL(10,2) — NOT NULL
  • vip_pass_deduction_amount — DECIMAL(10,2)
  • remaining_payment_amount — DECIMAL(10,2)
  • category_name — VARCHAR(255)
  • program_name — VARCHAR(255)
  • vip_pass_name — VARCHAR(255)
  • round — INT
  • cumulative_round — INT
  • is_vip_pass_deduction — BOOLEAN
  • note_skin_type — VARCHAR(255)
  • note_skin_type_etc — TEXT
  • note_strength — VARCHAR(255)
  • note_strength_etc — TEXT
  • note_management_time — VARCHAR(255)
  • note_management_time_etc — TEXT
  • note_management_focus_area — VARCHAR(255)
  • note_management_focus_etc — TEXT
  • photo_url — TEXT
  • contributions — JSON
  • treatment_id — INT
  • program_id — INT
  • store_id — INT
  • coupon_id — INT
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP
  • Field

vip_pass_purchase_log

  • ID (id) — Primary key — NOT NULL
  • Customer Id (customer_id2) — UUID — Foreign key → Customers (implemented).Customer Id — NOT NULL
  • type — VARCHAR(255) — REFUND,SALE
  • is_purchased_on_admin — BOOLEAN
  • apply_scope — VARCHAR(255)
  • quantity — INT
  • payment_amount — DECIMAL(15,2)
  • cash_paid_amount — DECIMAL(15,2)
  • card_paid_amount — DECIMAL(15,2)
  • account_paid_amount — DECIMAL(15,2)
  • unpaid_amount — DECIMAL(15,2)
  • klime_pay_amount — DECIMAL(15,2)
  • points_earned — INT
  • points_used — INT
  • is_cash_receipt — BOOLEAN
  • is_account_receipt — BOOLEAN
  • date — TIMESTAMP — NOT NULL
  • memo — TEXT
  • customer_id — INT — NOT NULL
  • vip_pass_id — INT — NOT NULL
  • coupon_id — INT
  • customer_vip_pass_id — INT
  • refund_customer_vip_pass_id — INT
  • store_id — INT
  • period_type — VARCHAR(255)
  • period_start — TIMESTAMP
  • period_end — TIMESTAMP
  • unit_price — INT
  • card_type — VARCHAR(255)
  • contributions — JSON
  • is_refund_completed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • deleted_at — TIMESTAMP