11111
Tables (16)
t_sc_administrator
- ADMINISTRATOR_ID — bigint(20) — Primary key — NOT NULL
- USERNAME — varchar(255)
- NAME — varchar(255)
- AUTHORITY — int(11) — NOT NULL
- CONTACTS — varchar(255)
- CREATE_AT — datetime — NOT NULL
- POSITION — varchar(255)
- DEPARTMENT — varchar(255)
- EMAIL — varchar(255)
- MEMO — varchar(255)
- PHONE — varchar(255)
- PASSWORD — varchar(255)
- REFRESH_TOKEN — varchar(255)
t_sc_attr
- SC_ATTR_ID — bigint(20) — Primary key — NOT NULL
- NAME — varchar(255) — NOT NULL
- VALUE — varchar(255)
- SC_ID — bigint(20) — NOT NULL
t_sc_banner
- BANNER_ID — bigint(20) — Primary key — NOT NULL — ID
- TYPE — int(11) — 배너 Type ex)홈메인, 좌측배너, 우측배너, 바배너, GNB배너
- HOME_MAIN_TYPE — int(11) — 홈메인 Type ex) 일반, 룩스
- VIDEO_LOOKS_ID — varchar(255) — VIDEO_LOOKS_ID
- TITLE_NAME — varchar(1000)
- MEDIA_TYPE — int(1) — NOT NULL
- TITLE_MEDIA_PC — varchar(255) — PC 타이틀 이미지 URL
- THUMBNAIL_MEDIA_PC — varchar(255)
- TITLE_MEDIA_MOBILE — varchar(255) — Mobile 타이틀 이미지 URL
- THUMBNAIL_MEDIA_MOBILE — varchar(255)
- BUTTON_TEXT — varchar(255) — 버튼 텍스트
- LINK_PC — varchar(255) — pc 버튼 링크 URL
- LINK_MOBILE — varchar(255) — 모바일 버튼 링크 URL
- TEXT_LINE_1 — varchar(255) — 1단 텍스트
- TEXT_OPTION_1 — int(11) — 1단 텍스트 크게 작게
- TEXT_LINE_2 — varchar(255) — 2단 텍스트
- TEXT_OPTION_2 — int(11) — 2단 텍스트 크게 작게
- TEXT_LINE_3 — varchar(255) — 3단 텍스트
- TEXT_OPTION_3 — int(11) — 3단 텍스트 크게 작게
- BACKGROUND_COLOR — varchar(30)
- START_DATE — datetime — NOT NULL — 활성화 시작 날짜
- END_DATE — datetime — NOT NULL — 활성화 마지막 날짜
- CREATE_AT — datetime — NOT NULL — 생성, 업데이트 날짜
- SORT_NUMBER — bigint(20) — 정렬
- REGISTRANT — varchar(255) — 작성자
- IS_ACTIVE — int(1) — 활성화/비활성화
t_sc_banner_option
- BANNER_OPTION_ID — bigint(20) — Primary key — NOT NULL
- TYPE — tinyint(4) — 상단 배너, 하단배너
- FONT_SIZE — varchar(30) — 글자크기
- FONT_BOLD — tinyint(4) — 글자굵기
- FONT_COLOR — varchar(30) — 글자색
- BACKGROUND_COLOR — varchar(30) — 배경색
- REGISTRANT — varchar(20) — 등록자
- CREATE_AT — datetime — 생성, 업데이트 날짜
t_sc_category
- CATEGORY_ID — bigint(20) — Primary key — NOT NULL
- CATEGORY_PRODUCT_ID — bigint(20) — Foreign key → t_sc_category_product.CATEGORY_PRODUCT_ID — NOT NULL
- PARENT_CATEGORY_ID — bigint(20) — NOT NULL
- COLLECTION_TYPE — int(11) — NOT NULL
- CATEGORY_LEVEL — bigint(20) — NOT NULL
- NAME — varchar(255)
- URL — varchar(255)
- LABEL — varchar(255)
- MILEAGE_GIVE — tinyint(1) — NOT NULL
- ACTIVE — tinyint(4) — NOT NULL
- MEDIA_PC — varchar(45)
- MEDIA_MOBILE — varchar(45)
- MEMBER_ONLY — tinyint(4)
- DISCOUNT — tinyint(4)
t_sc_category_product
- CATEGORY_PRODUCT_ID — bigint(20) — Primary key — NOT NULL
- CATEGORY_ID — bigint(20) — NOT NULL
- DISPLAY_ORDER — int(11) — NOT NULL
- PRODUCT_ID — bigint(20) — NOT NULL
t_sc_coordination
- COORDINATION_ID — bigint(20) — Primary key — NOT NULL — ID
- MENU_TYPE — int(11) — 메뉴 목록. ex) MEN, WOMEN, NEW ARRIVALS
- GENDER — int(11) — 성별
- SEASON — varchar(10)
- COLLECTION_TYPE — varchar(30)
- SORT_NUMBER — bigint(20)
- TITLE — varchar(255) — 제목
- TITLE_MEDIA — varchar(255)
- MEDIAS — varchar(1000)
- PRODUCT_LIST — varchar(255) — 관련 상품 리스트
- CREATE_AT — datetime — NOT NULL
- REGISTRANT — varchar(30)
- IS_ACTIVE — int(1)
t_sc_customer
- CUSTOMER_ID — bigint(20) — Primary key — NOT NULL
- STATE — tinyint(4) — NOT NULL
- DELETE_REASON — varchar(20)
- ACC_ORDER_COUNT — int(11)
- ACC_ORDER_TOTAL — int(11)
- BIRTH_DAY — varchar(45)
- CREATE_AT — datetime
- USERNAME — varchar(45) — NOT NULL
- NAME — varchar(45)
- GENDER — varchar(45)
- LAST_DATE — datetime
- LOGIN_DATE — datetime
- LOGIN_COUNT — int(11)
- PASSWORD — varchar(256)
- PASSWORD_AT — datetime
- PASSWORD_CHANGE_REQUIRED — tinyint(4)
- UNIQUE_KEY — varchar(256)
- PHONE_NUMBER — varchar(45)
- RECEIVE_EMAIL — tinyint(4)
- RECEIVE_SMS — tinyint(4)
- IS_REGISTERED — tinyint(4)
- UPDATE_AT — datetime
- EMAIL — varchar(45)
- RECEIVE_EMAIL_AT — datetime
- RECEIVE_SMS_AT — datetime
- ERP_ID — bigint(20)
- SC_MONEY_NUMBER — varchar(128)
- GIFT_POINT_NUMBER — varchar(128)
- BAR_CODE — varchar(128)
- GRADE — int(11)
- USER_CODE — varchar(45)
- PLATFORM — tinyint(4) — NOT NULL
t_sc_customer_address
- CUSTOMER_ADDRESS_ID — bigint(20) — Primary key — NOT NULL
- CUSTOMER_ID — bigint(20)
- ADDRESS_NAME — varchar(45)
- ADDRESS — varchar(256)
- ADDRESS_DETAIL — varchar(256)
- NAME — varchar(45)
- IS_DEFAULT — tinyint(4)
- POSTAL_CODE — varchar(45)
- PHONE_NUMBER — varchar(45)
- TEL_NUMBER — varchar(45)
t_sc_dau
- CUSTOMER_ID — bigint(20)
- CREATE_AT — datetime — NOT NULL
t_sc_exhibition
- EXHIBITION_ID — bigint(20) — Primary key — NOT NULL
- TITLE — varchar(255)
- START — datetime — NOT NULL
- END — datetime — NOT NULL
- ADMIN — varchar(255)
- ACTIVE — int(11) — NOT NULL
- CREATE_AT — datetime — NOT NULL
- EXHIBITION — int(11) — NOT NULL
- TOP_BANNER_MEDIA — varchar(255)
- EXHIBITION_BOTTOM — int(11) — NOT NULL
- DELETED — tinyint(4) — NOT NULL
- THUMBNAIL_MEDIA — varchar(45)
- LAYOUT — tinyint(4) — NOT NULL
t_sc_exhibition_comment
- EXHIBITION_COMMENT_ID — bigint(20) — Primary key — NOT NULL
- EXHIBITION_ID — bigint(20) — NOT NULL
- CONTENT — varchar(255)
- USERNAME — varchar(255)
- CUSTOM_ID — bigint(20) — NOT NULL
- CREATE_AT — datetime — NOT NULL
- ACTIVE — tinyint(1) — NOT NULL
t_sc_exhibition_template
- EXHIBITION_TEMPLATE_ID — bigint(20) — Primary key — NOT NULL
- EXHIBITION_ID — bigint(20) — NOT NULL
- TYPE — tinyint(4) — NOT NULL
- EXTRA — varchar(255)
- PLATFORM — tinyint(4)
- DATA — mediumtext
- PROPERTY — varchar(255)
t_sc_faq
- ID — bigint(20) — Primary key — NOT NULL
- TYPE — int(11) — NOT NULL
- QUESTION — varchar(255)
- ANSWER — varchar(1000)
t_sc_fld
- SC_FLD_ID — bigint(20) — Primary key — NOT NULL
- AUDIT_ADM_DESC — longtext
- DATE_CREATED — datetime
- CREATED_BY — bigint(20)
- CREATED_BY_USER — varchar(255)
- FLD_KEY — varchar(255)
- LOB_VALUE — longtext
- VALUE — varchar(255)
- DATE_UPDATED — datetime
- UPDATED_BY — bigint(20)
- UPDATED_BY_USER — varchar(255)
t_sc_fld_map
- T_SC_SC_FIELD_ID — bigint(20) — Primary key — NOT NULL
- MAP_KEY — varchar(255) — NOT NULL
- SITE_ID — bigint(20)
- SC_ID — bigint(20) — NOT NULL
- SC_FLD_ID — bigint(20) — Foreign key → t_sc_fld.SC_FLD_ID