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