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)