stylingBooth-Type1
Tables (10)
CC_OS_NANA_V1_CustomerLog
- request — int(11) — Primary key — NOT NULL
- tag_clothes — varchar(30)
- customer_time — datetime
CC_OS_NANA_V1_cloth
- tag_clothes — varchar(50) — Primary key — NOT NULL
- tag_check_clothes — varchar(50)
- tag_in_fitroom — varchar(50)
- product_code — varchar(30)
- store_id — varchar(30)
- product_id — varchar(30)
- name — varchar(50) — NOT NULL
- color — varchar(30) — NOT NULL
- size — varchar(30) — NOT NULL
- gender — varchar(30) — NOT NULL
- price — varchar(30) — NOT NULL
- image_link1 — varchar(250)
- image_link2 — varchar(250)
- image_link3 — varchar(250)
- tag_hanger — varchar(30) — NOT NULL
- tag_check_hanger — varchar(50)
- name_hanger — varchar(30)
- location_hanger — varchar(30)
- pairing — varchar(30)
- time_pairing — varchar(30)
- location_statement — varchar(30)
- tag_selection — varchar(30)
- store — varchar(50) — NOT NULL
- sold_time — datetime
- customer_type — varchar(50)
- group — varchar(5)
CC_OS_NANA_V1_scripts
- script_id — int(11) — Primary key — NOT NULL
- type — varchar(100) — NOT NULL
- script — varchar(255) — NOT NULL
CC_OS_NANA_V1_video
- seq — int(11) — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- url — varchar(255) — NOT NULL
- play — tinyint(1) — NOT NULL
- stop — tinyint(1) — NOT NULL
- destination_type — varchar(50)
- video_length — int(11)
CustomerLog
- request — int(11) — Primary key — NOT NULL
- tagged_at (인식된 시각) — datetime
- played_at (재생된 시각) — datetime
- cloth_id (tag_clothes) — int(11) — Foreign key → cloth.id — NOT NULL
cloth
- id (tag_clothes) — int(11) — Primary key — NOT NULL
- cloth_code (RFID에 들어있는 코드) — varchar(50)
- product_code (옷의 제품 코드) — varchar(50)
- product_id (?) — varchar(30)
- name (옷 이름) — varchar(50) — NOT NULL
- color — varchar(30) — NOT NULL
- size (사이즈) — varchar(30) — NOT NULL
- gender (성별) — varchar(30) — NOT NULL
- price — int — NOT NULL
- id (store) — int(11) — Foreign key → store.id — NOT NULL
scripts
- script_id — int(11) — Primary key — NOT NULL
- type — varchar(100) — NOT NULL
- script — varchar(255) — NOT NULL
store (Untitled)
- id (store) — int(11) — Primary key — NOT NULL
- name (매장 이름) — varchar(50)
video
- seq — int(11) — Primary key — NOT NULL
- title — varchar(100) — NOT NULL
- url — varchar(255) — NOT NULL
- destination_type — varchar(50)
- video_length — int(11)
video_mapping
- seq — int(11) — Primary key — NOT NULL
- cloth_id (tag_clothes) — int(11) — Foreign key → cloth.id — NOT NULL
- video_id (video) — int(11) — Foreign key → video.seq — NOT NULL