findMachine

Tables (29)

adPayLogs (광고결제)

  • Key (id) — int — Primary key — NOT NULL
  • Field (amount) — int — NOT NULL — 금액
  • Field (rank) — int — NOT NULL — 순위
  • Field (startDate) — string — NOT NULL — 광고 시작일
  • Field (endDate) — string — NOT NULL — 광고 종료일
  • Field (status) — int — NOT NULL — 상태
  • Field (isPaid) — int — NOT NULL — 결제상태
  • Field (orderId) — string — NOT NULL — 주문id
  • Field (paymentKey) — string — 토스 paymentKey
  • Key (userId) — int — Foreign key → users.Key — NOT NULL
  • Key (primaryCategoryId) — int — Foreign key → primaryCategories.Key — NOT NULL
  • Key (secondaryCategoryId) — int — Foreign key → tertiarayCategories.Key — NOT NULL
  • Key (productId) — int — Foreign key → products.Key — NOT NULL

addresses (주소)

  • Key (id) — int — Primary key — NOT NULL
  • Field (addressName) — string — NOT NULL — 주소명
  • Field (address) — string — NOT NULL — 주소
  • Field (detailAddress) — string — NOT NULL — 상세주소
  • Field (latitude) — string — 위도
  • Field (longitude) — string — 경도
  • Field (region1DepthName) — string — 1뎁스 이름
  • Field (region1DepthLatitude) — string — 1뎁스 위도
  • Field (region1DepthLongitude) — string — 1뎁스 경도
  • Field (region2DepthName) — string — 2뎁스 이름
  • Field (region2DepthLatitude) — string — 2뎁스 위도
  • Field (region2DepthLongitude) — string — 2뎁스 경도
  • Field (region3DepthName) — string — 3뎁스 이름
  • Field (region3DepthLatitude) — string — 3뎁스 위도
  • Field (region3DepthLongitude) — string — 3뎁스 경도
  • Field (region4DepthName) — string — 4뎁스 이름
  • Field (region4DepthLatitude) — string — 4뎁스 위도
  • Field (region4DepthLongitude) — string — 4뎁스 경도
  • Key (companyId) — int — Foreign key → companies.Key — NOT NULL

authCodes (인증번호)

  • Key (id) — int — Primary key — NOT NULL
  • Field (code) — int — NOT NULL — 인증코드
  • Field (phone) — string — NOT NULL — 휴대폰번호

businessCategories (사업부문)

  • Key (id) — int — Primary key — NOT NULL
  • Field (businessCategoryName) — string — NOT NULL — 이름

businessCategoryLink (회사정보-사업부문)

  • Key (id) — int — Primary key — NOT NULL
  • Key (companyId) — int — Foreign key → companies.Key — NOT NULL
  • Key (businessCategoryId) — int — Foreign key → businessCategories.Key — NOT NULL

companies (회사정보)

  • Key (id) — int — Primary key — NOT NULL
  • Field (companyName) — string — NOT NULL — 회사명
  • Field (ceoName) — string — NOT NULL — 대표자명
  • Field (businessNumber) — int — NOT NULL — 사업자등록번호
  • Field (tel) — int — NOT NULL — 대표번호
  • Field (fax) — int — NOT NULL — 팩스번호
  • Field (foundedDate) — string — NOT NULL — 설립일
  • Field (title) — string — NOT NULL — 대표제목
  • Field (introTitle) — string — NOT NULL — 소개제목
  • Field (introSubTitle) — string — NOT NULL — 소개부제목
  • Field (intro) — text — NOT NULL — 회사소개
  • Key (userId) — int — Foreign key → users.Key — NOT NULL

companyCategories (기업유형)

  • Key (id) — int — Primary key — NOT NULL
  • Field (companyCategoryName) — string — NOT NULL — 이름

companyCategoryLink (회사정보-기업유형)

  • Key (id) — int — Primary key — NOT NULL
  • Key (companyId) — int — Foreign key → companies.Key — NOT NULL
  • Key (companyCategoryId) — int — Foreign key → companyCategories.Key — NOT NULL

companyHistories (연혁)

  • Key (id) — int — Primary key — NOT NULL
  • Field (date) — int — NOT NULL — 날짜
  • Field (description) — string — NOT NULL — 설명
  • Key (companyId) — int — Foreign key → companies.Key — NOT NULL

consults (상담예약)

  • Key (id) — int — Primary key — NOT NULL
  • Field (consultType) — int — NOT NULL — 타입
  • Field (consultCategory) — int — NOT NULL — 구분
  • Field (consultDate) — string — NOT NULL — 예약일
  • Field (consultTime) — string — NOT NULL — 예약 시간
  • Field (companyName) — string — NOT NULL — 회사명
  • Field (preferredDate) — string — NOT NULL — 납품 희망일
  • Field (contents) — text — NOT NULL — 상담 희망내용
  • Field (status) — int — 상담 상태
  • Field (region) — string — NOT NULL — 상담 지역
  • Key (userId) — int — Foreign key → users.Key — NOT NULL
  • Key (productId) — int — Foreign key → products.Key — NOT NULL

images (이미지)

  • Key (id) — int — Primary key — NOT NULL
  • Field (imagePath) — string — NOT NULL — 경로
  • Field (imageType) — string — NOT NULL — 이미지타입
  • Key (companyId) — int — Foreign key → companies.Key
  • Key (productId) — int — Foreign key → products.Key

keywords (검색키워드)

  • Key (id) — int — Primary key — NOT NULL
  • Field (keywordName) — string — NOT NULL — 키워드명
  • Key (companyId) — int — Foreign key → companies.Key
  • Key (productId) — int — Foreign key → products.Key

mainFields (주요분야)

  • Key (id) — int — Primary key — NOT NULL
  • Field (mainFieldName) — string — NOT NULL — 주요분야명
  • Key (companyId) — int — Foreign key → companies.Key — NOT NULL

notices (공지사항)

  • Key (id) — int — Primary key — NOT NULL
  • Field (noticeTitle) — string — NOT NULL — 공지제목
  • Field (noticeConetents) — text — NOT NULL — 공지내용

payDetails (결제 상세)

  • Key (id) — int — Primary key — NOT NULL
  • Field (amount) — int — NOT NULL — 금액
  • Field2 (payType) — string — NOT NULL — 결제타입 ('간편결제', '카드')
  • Field (cardType) — string — 카드타입('신용','체크')
  • Field (cardNumber) — string — 카드번호
  • Field (approvedAt) — string — NOT NULL — 승인일
  • Key (adpayLogsId) — int — Foreign key → adPayLogs.Key
  • Key (subscriptionPayLogsId) — int — Foreign key → subscriptionPayLogs.Key

primaryCategories (대분류)

  • Key (id) — int — Primary key — NOT NULL
  • Field (primaryCategoryName) — string — NOT NULL — 대분류명

productAddressLink (제품 - 주소 링크)

  • Key (id) — int — Primary key — NOT NULL
  • Key (productId) — int — Foreign key → products.Key — NOT NULL
  • Key (addressId) — int — Foreign key → addresses.Key — NOT NULL

productCategoryLink (제품 - 분류)

  • Key (id) — int — Primary key — NOT NULL
  • Key (productId) — int — Foreign key → products.Key — NOT NULL
  • Key (tertiaryCategoryId) — int — Foreign key → tertiarayCategories.Key — NOT NULL
  • Key (secondaryCategoryId) — int — Foreign key → secondaryCategories.Key — NOT NULL
  • Key (primaryCategoryId) — int — Foreign key → primaryCategories.Key — NOT NULL

productTypeLink (제품 - 제품타입)

  • Key (id) — int — Primary key — NOT NULL
  • Key (productId) — int — Foreign key → products.Key — NOT NULL
  • Key (productTypeId) — int — Foreign key → productTypes.Key — NOT NULL

productTypes (제품 타입)

  • Key (id) — int — Primary key — NOT NULL
  • Field (productTypeName) — string — NOT NULL — 타입명

products (제품)

  • Key (idx) — int — Primary key — NOT NULL
  • Field (productName) — string — NOT NULL — 제품명
  • Field (modelName) — string — NOT NULL — 모델명
  • Field (madeDate) — string — NOT NULL — 제조년월
  • Field (basicSpecs) — string — NOT NULL — 기본사양
  • Field (warranty) — string — NOT NULL — 품질보증
  • Field (afterService) — string — NOT NULL — a/s
  • Field (delivery) — string — NOT NULL — 배송
  • Field (stockQuantity) — int — NOT NULL — 재고수량
  • Field (price) — int — NOT NULL — 가격
  • Field (productDetail) — text — NOT NULL — 제품 상세
  • Field (order) — int — NOT NULL — 순서
  • Field (status) — int — NOT NULL — 활성상태
  • Key (companyIdx) — int — Foreign key → companies.Key — NOT NULL

reviews (후기)

  • Key (id) — int — Primary key — NOT NULL
  • Field (reviewContents) — text — NOT NULL — 리뷰내용
  • Key (userId) — int — Foreign key → users.Key — NOT NULL
  • Key (consultId) — int — Foreign key → consults.Key — NOT NULL

secondaryCategories (중분류)

  • Key (id) — int — Primary key — NOT NULL
  • Field (secondaryCategoryName) — string — NOT NULL — 중분류명
  • Key (primaryCategoryId) — int — Foreign key → primaryCategories.Key — NOT NULL

subscriptionPayLogs (유저 - 정기결제)

  • Key (id) — int — Primary key — NOT NULL
  • Field (startDate) — string — NOT NULL — 시작일
  • Field2 (endDate) — string — NOT NULL — 종료일
  • Field (status) — int — NOT NULL — 상태
  • Field (isPaid) — int — NOT NULL — 결제상태
  • Field (orderId) — string — NOT NULL — 주문id
  • Field (paymentKey) — string — 토스 paymentKey
  • Key (userId) — int — Foreign key → users.Key — NOT NULL
  • Key (subscriptionId) — int — Foreign key → subscriptions.Key — NOT NULL

subscriptions (정기결제)

  • Key (id) — int — Primary key — NOT NULL
  • Field (amount) — int — NOT NULL — 금액
  • Field2 (orderName) — string — NOT NULL — 정기결제명
  • Field (orderDescription) — string — NOT NULL — 정기결제 설명

tertiarayCategories (소분류)

  • Key (id) — int — Primary key — NOT NULL
  • Field (tertiaryCategoryName) — string — NOT NULL — 소분류명
  • Key (secondaryCategoryId) — int — Foreign key → secondaryCategories.Key — NOT NULL

userVisits (누적방문자)

  • Key (id) — int — Primary key — NOT NULL
  • Field (visitDate) — string — NOT NULL — 방문일
  • Field (visitCount) — int — NOT NULL — 방문횟수

users (유저)

  • Key (id) — int — Primary key — NOT NULL
  • Field (loginId) — string — NOT NULL — 로그인 아이디
  • Field (password) — string — NOT NULL — 비밀번호
  • Field (userName) — string — NOT NULL — 이름
  • Field (email) — string — NOT NULL — 이메일
  • Field (phone) — int — NOT NULL — 휴대폰번호
  • Field (address) — string — NOT NULL — 주소
  • Field (detailAddress) — string — NOT NULL — 상세주소
  • Field (privacy) — int — NOT NULL — 개인정보 동의
  • Field (service) — int — NOT NULL — 서비스이용 동의
  • Field (marketing) — int — NOT NULL — 마케팅활용 동의
  • Field (role) — string — NOT NULL — 역할
  • Field (status) — int — NOT NULL — 활성: 1, 비활성: 0
  • Field (refreshToken) — string — 리프레시토큰
  • Field (grade) — int — 등급
  • Field (customerKey) — string — NOT NULL — 고객키

wishLists (찜리스트)

  • Key (id) — int — Primary key — NOT NULL
  • Field (wishType) — int — NOT NULL — 찜 타입
  • Key (userId) — int — Foreign key → users.Key — NOT NULL
  • Key (productId) — int — Foreign key → products.Key — NOT NULL