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_MIDDLEMAN (중매인)

  • SEQ_USER (사용자고유번호)

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)