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