cclime

Tables (9)

admin

  • admin_id — int(11) — Primary key — NOT NULL
  • store_id — int(11) — Foreign key → store.store_id
  • admin_identifier — varchar(50) — NOT NULL
  • password — varchar(255) — NOT NULL
  • is_enable — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

beautyst

  • beautyst_id — int(11) — Primary key — NOT NULL
  • store_id — int(11) — Foreign key → store.store_id — NOT NULL
  • beautyst_name — varchar(20) — NOT NULL
  • beautyst_birth — date
  • position — varchar(20)
  • beautyst_email — varchar(50)
  • beautyst_phone — varchar(15)
  • beautyst_career — varchar(20)
  • cclime_career — varchar(20)
  • certificate — varchar(50)
  • address — varchar(255)
  • beautyst_img — varchar(500)
  • note — varchar(255)
  • is_enable — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

comment

  • comment_id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → user.user_id — NOT NULL
  • event_id — int(11) — Foreign key → event.event_id — NOT NULL
  • comment_content — varchar(500) — NOT NULL
  • is_enable — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

event

  • event_id — int(11) — Primary key — NOT NULL
  • event_start — date — NOT NULL
  • event_end — date — NOT NULL
  • event_title — varchar(50) — NOT NULL
  • event_content — varchar(1000)
  • event_img — varchar(500)
  • comment_enable — enum — NOT NULL
  • event_state — enum
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

grade

  • grade_id — int(11) — Primary key — NOT NULL
  • grade_name — varchar(50) — NOT NULL
  • grade_condition — int(11) — NOT NULL
  • grade_rank — int(11) — NOT NULL

reservation

  • reservation_id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → user.user_id — NOT NULL
  • store_id — int(11) — Foreign key → store.store_id — NOT NULL
  • beautyst_id — int(11) — Foreign key → beautyst.beautyst_id
  • program_id — int(11) — Foreign key
  • prepaid_id — int(11) — Foreign key
  • retention_id — int(11) — Foreign key
  • temporarily — timestamp
  • state — enum
  • create_at — timestamp — NOT NULL
  • updated_at — timestamp

store

  • store_id — int(11) — Primary key — NOT NULL
  • store_name — varchar(100) — NOT NULL
  • business_num — varchar(100) — NOT NULL
  • store_type — enum — NOT NULL
  • representative — varchar(50) — NOT NULL
  • tel — varchar(15)
  • email — varchar(50)
  • address — varchar(255) — NOT NULL
  • detail_address — VARCHAR(255)
  • bed — int(2) — NOT NULL
  • parking — varchar(500)
  • store_img — varchar(500)
  • store_thumbnail — VARCHAR(255)
  • week_open — time — NOT NULL
  • week_close — time — NOT NULL
  • sat_open — time
  • sat_close — time
  • sun_open — time
  • sum_close — time
  • holiday_open — time
  • holiday_close — time
  • launch_time — time — NOT NULL
  • is_enable — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

store_customer

  • customer_id — int(11) — Primary key — NOT NULL
  • user_id — int(11) — Foreign key → user.user_id — NOT NULL
  • store_id — int(11) — Foreign key → store.store_id — NOT NULL
  • is_enable — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp

user

  • user_id — int(11) — Primary key — NOT NULL
  • grade_id — int(11) — Foreign key → grade.grade_id — NOT NULL
  • email — varchar(255) — NOT NULL
  • password — varchar(255)
  • user_name — varchar(50) — NOT NULL
  • birth — date
  • phone — varchar(15) — NOT NULL
  • gender — enum — NOT NULL
  • address — varchar(100)
  • skin — enum
  • allergy — enum
  • trouble — enum
  • aesthetic — enum
  • medicine — enum
  • surgery — enum
  • pregnancy — enum
  • caution — varchar(500)
  • cclime_route — varchar(255)
  • marry — enum
  • tel — varchar(15)
  • wedding_day — date
  • route — varchar(255)
  • is_enable — enum — NOT NULL
  • created_at — timestamp — NOT NULL
  • updated_at — timestamp
  • manager_comment — varchar(500)
  • push_token — VARCHAR(255)
  • attention — VARCHAR(255)