maxi-global

Tables (18)

Untitled

    admin_accounts (관리자 계좌)

    • id (키) — Primary key — NOT NULL
    • ownername (수취인명)
    • bankname (은행명)
    • banknum (계좌번호)

    admins (관리자)

    • id (키) — Primary key — NOT NULL
    • role_id (역할 키) — Primary key — NOT NULL
    • username (아이디)
    • password (비밀번호)
    • Field2

    branches (브랜치)

    • Key — Primary key — NOT NULL

    categories (제품카테고리)

    • id (키) — Primary key — NOT NULL
    • name (이름)
    • order (정렬순서)
    • parent_id (1차카테고리 키)
    • is_disabled (사용여부)
    • message (노출메세지)

    category_word_filters (카테고리별 단어필터링)

    • id (키) — Primary key — NOT NULL
    • category_id (카테고리 키) — Foreign key → categories.id — NOT NULL
    • word (단어)
    • seller_id (Field)

    countries (국가)

    • code (국가코드) — Primary key
    • name (국가이름)
    • logo (국가로고)
    • is_register (등록마켓 유무)
    • is_collect (수집마켓유무)
    • currency (화폐 단위)

    exchage_rates (환율)

    • id (키) — Primary key — NOT NULL
    • departure_country_code (출발국가코드)
    • arrival_country_code (도착국가코드)
    • standard_price (기준가격)
    • exchage_price (값)

    market_word_filters (마켓별 단어필터링)

    • id (키) — Primary key — NOT NULL
    • market_code (마켓코드) — Foreign key → markets.code — NOT NULL
    • word (단어)
    • seller_id (Field)

    markets (마켓)

    • code (마켓코드) — Primary key — NOT NULL
    • country_code (국가코드) — Foreign key → countries.code
    • name (마켓이름)
    • logo (마켓로고)
    • is_register (등록)
    • is_collect (수집)
    • has_branch (집하지 여부)
    • market_rate (마켓 수수료)

    privilege_role (역할별 권한)

    • id (Key) — Primary key — NOT NULL
    • role_id (Key2) — Foreign key → role.id — NOT NULL
    • privilege_id (Key3) — Foreign key → privileges.id — NOT NULL

    privileges (권한)

    • id (Key) — Primary key — NOT NULL
    • name (권한명)
    • dscription (설명)
    • Field

    register_plans (등록요금제)

    • id (키) — Primary key — NOT NULL
    • code (마켓코드) — Foreign key → markets.code — NOT NULL
    • order (순서)
    • monthly_pirce (월요금)
    • setting_price (셋팅요금)
    • total_seller (총 허용 셀러 수)
    • current_seller (현재 셀러 수)
    • Field

    role (역할)

    • id (Key) — Primary key — NOT NULL
    • name (역할명)
    • dscription (설명)
    • Field

    sellers (셀러)

    • id (키) — Primary key — NOT NULL
    • username (로그인아이디)
    • password (비밀번호)
    • cell (휴대폰번호)
    • terms_ids (약관 동의 여부)
    • is_setting (서비스셋팅여부)
    • latest_login (마지막로그인)
    • name (이름)
    • profile_image (프로필이미지)
    • collect_amount (수집 가능 양)
    • register_amount (등록 가능 양)
    • Field

    service_plans (서비스요금제)

    • id (키) — Primary key — NOT NULL
    • level (레벨)
    • name (이름)
    • can_extend (연장가능여부)
    • collect_amount (수집 량)
    • register_amount (등록 량)
    • update_amount (업데이트량)
    • store_amount (관리저장 량)
    • monthly_price (월 요금)
    • setting_price (셋팅요금)

    shipping_charges (배송비)

    • id (키) — Primary key — NOT NULL
    • departure_country_code (출발국가코드)
    • arrival_country_code (도착국가코드)
    • weight_unit (무게 단위)
    • default_weight (기본 무게)
    • increase_step_weight (추가무게)
    • default_charge (기본 요금)
    • increase_step_charge (추가요금)
    • currency_code (화폐 코드)
    • shipping_term (배송기간)

    terms (약관)

    • id (키) — Primary key — NOT NULL
    • title (제목)
    • content (내용)
    • is_required (필수여부)
    • is_disabled (표시여부)