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)