ita_shopping
Tables (17)
PRODUCT_SCOPE (CopyOf상품상세)
- SEQ_USER (상품공유번호) — Primary key — NOT NULL
- GRADE_A (상품설명) — Primary key — NOT NULL
- GRADE_B (상품상태) — Primary key
- GRADE_C (재고유형)
- GRADE_D (Field)
- GRADE_E (Field2)
- GRADE_F (Field3)
- GRADE_G (Field4)
- GRADE_H (Field5)
- GRADE_I (Field6)
- Field7
T_BUSINESS (사업자정보)
- SEQ_BUSINESS (사업자고유번호)
- SEQ_USER (사용자고유번호)
- REG_DATE (등록일)
- BISINESS_NAME (사업자명)
- BUSINESS_NUMBER (사업자번호)
- BUSINESS_ADDR (주소) — S : 판매자 B : 구매자 A : 판매자, 구매자
- BUSINESS_ADDR2 (주소상세)
- YN_AGREE (동의여부)
- MARKET_TYPE (Field)
- GRADE (등급)
- OPENING_START_HOUR (영업시작시간)
T_BUYER (바이어)
- SEQ_USER (사용자고유번호) — Primary key — NOT NULL
T_CANCEL_PRODUCT (취소상품정보)
- SEQ_CANCEL (취소상품고유번호)
- SEQ_PRODUCT (상품고유번호)
- ITA_SEQ_PRODUCT (이타상품고유번호)
- SEQ_USER (사용자 고유번호)
- MARKET_TYPE (Field)
- PRODUCT_NUMBER (상품번호)
- PRODUCT_TYPE (판매,구매구분)
- TRANSACTION_TYPE (Field2)
- PRODUCT_COUNT (수량)
- START_DATE (시작일)
- END_DATE (종료아ㅣㄹ)
- MODIFY_DATE (Field3)
T_CODE (공통코드)
- grp_code (그룹코드번호) — Primary key — NOT NULL
- code (코드번호)
- name (인증키)
- ret_code (사용유무)
T_CONSUMER (소비자)
- SEQ_USER (사용자고유번호) — Primary key — NOT NULL
T_PRODUCT (상품정보)
- Key — Primary key — NOT NULL
- SEQ_PRODUCT (상품고유번호)
- ITA_SEQ_PRODUCT (이타상품 고유번호)
- SEQ_USER (사용자고유번호)
- MARKET_TYPE (시장유형)
- PRODUCT_NUMBER (상코번호)
- PRODUCT_TYPE (판매,구매 구분)
- PRODUCT_CATEGORY (카테고리)
- PRODUCT_COUNT (수량)
- START_DATE (시작일)
- END_DATE (종료일)
- PRODUCT_NAME (상품명)
- PRODUCT_PRICE (상품가격)
- PRODUCT_RATE (할인율)
- PRODUCT_DISCOUNT (할인가격)
- CONSUMER_PRICE (소비자가격)
- PRODUCT_IMAGE (대표이미지)
- STATUS (상태)
T_PRODUCT_DEAIL (상품상세)
- SEQ_USER (상품공유번호) — Primary key — NOT NULL
- PRODUCT_CONTENTS (상품설명) — Primary key — NOT NULL
- PRODUCT_STATUS (상품상태) — Primary key
- PRODUCT_STOCK (재고유형)
T_PRODUCT_IMAGE (CopyOf바이어2)
- SEQ_USER (사용자고유번호) — Primary key — NOT NULL
T_PRODUCT_TRADE (CopyOfCopyOf바이어2)
- SEQ_USER (사용자고유번호) — Primary key — NOT NULL
- SEQ_PRODUCT (상품고유번호) — Primary key — NOT NULL
- TRADE_TYPE (거래타입) — Primary key — NOT NULL
- TRADE_DAY (거래일) — Primary key — NOT NULL
- TRADE_RESULT (거래결과) — Primary key — NOT NULL
T_SHIPPER (출하주)
- SEQ_USER (사용자고유번호) — Primary key — NOT NULL
T_SHIPPER (CopyOf바이어)
- SEQ_USER (사용자고유번호) — Primary key — NOT NULL
T_SMS_AUTH (인증번호)
- Key — Primary key — NOT NULL
- PHONE (연락처)
- AUTH_KEY (인증키)
- RET_CODE (결과값)
- AUTH_DATE (인증일자)
T_TEMP_PASSWORD (임시비밀번호)
- id (회원아이디)
- temp_password (임시비밀번호)
- start_day (시작일) — S : 판매자 B : 구매자 A : 판매자, 구매자
- end_day (종료일)
T_USER (회원정보)
- SEQ_SHOP (매장고유번호) — Primary key — NOT NULL
- ID (회원아이디)
- NAME (회원명)
- REG_DATE (가입일)
- PHONE (연락처)
- YN_AGREE (동의여뷰)
- SEQ_USER (회원고유번호)
- PWD (비밀번호)
- BUSINESS_NICK (닉네임)
- BUSINESS_NAME (상호명)
- BUSINESS_NUMBER (사업자 번호)
- MAREKT_TYPE (시장유형)
- GRADE (사용자등급)
T_USER_LOGIN (로그인정보)
- Key — Primary key — NOT NULL
- SEQ_USER (회원고유번호)
- LOGIN_DATE (로그인일자)
- DEVICE (접속기기)
- LOGOUT_DATE (로그아웃일자)
- LOGIN_IP (접속IP)
- USER_AGENT (Field)