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