HP_2026_PRO_01

Tables (14)

Board (HP_Board)

  • HP_B_Seq (등록번호) — INT — Primary key — NOT NULL
  • HP_B_Title (제목) — Varchar(100) — NOT NULL
  • HP_B_Details (상세내용) — TEXT — NOT NULL
  • HP_B_Author (작성자) — Varchar(40) — NOT NULL
  • HP_B_RegDate (작성일자) — DATETIME — NOT NULL
  • HP_B_Count (조회수) — INT — NOT NULL

Board (HP_Board_Comm)

  • HP_Bc_Seq (댓글 등록번호) — INT — Primary key — NOT NULL
  • HP_B_Seq (등록번호) — INT — Foreign key → Board.HP_B_Seq — NOT NULL
  • HP_Bc_Author (댓글 작성자) — Varchar(40)
  • HP_Bc_Details (댓글 내용) — Varchar(2000)
  • HP_Bc_RegDate (댓글 작성일자) — DATETIME — NOT NULL

DeliveryAddress (HP_Product_Customer)

  • HP_PC_Seq (주문자 번호) — int — Primary key — NOT NULL
  • HP_PO_Seq (주문 번호) — int — Foreign key → ProductOrder.HP_PO_Seq — NOT NULL
  • HP_M_Hp (전화번호2) — Varchar(15) — Foreign key → ProductOrder.HP_M_Hp — NOT NULL
  • HP_PDP_Seq (배송정책 번호) — int — Foreign key → ProductOrder.HP_PDP_Seq — NOT NULL
  • HP_PC_Email (주문자 이메일) — Varchar(254)

DeliveryAddress (HP_Product_DeliveryAddress)

  • HP_PDA_Seq (주문 배송지 번호) — int — Primary key — NOT NULL
  • HP_PO_Seq (주문 번호) — int — Foreign key → ProductOrder.HP_PO_Seq — NOT NULL
  • HP_M_Hp (전화번호2) — Varchar(15) — Foreign key → ProductOrder.HP_M_Hp — NOT NULL
  • HP_PDP_Seq (배송정책 번호) — int — Foreign key → ProductOrder.HP_PDP_Seq — NOT NULL
  • HP_PDA_Name (수령인 이름) — Varchar(40)
  • HP_PDA_Hp (수령인 번호) — Varchar(15)
  • HP_PDA_PostalCode (우편번호) — Varchar(10)
  • HP_PDA_Address (기본주소) — varchar(200)
  • HP_PDA_AddressDetail (상세주소) — varchar(200)
  • HP_PDA_Request (배송 요청사항) — varchar(500)
  • Field

DeliveryPolicy (HP_Product_DeliveryPolicy)

  • HP_PDP_Seq (배송정책 번호) — int — Primary key — NOT NULL
  • HP_PDP_Type (배송 유형 코드) — Varchar(20)
  • HP_PDP_Name (배송정책명) — Varchar(50)
  • HP_PDP_Fee (주문 단위 배송비) — int
  • HP_PDP_IsActive (사용 여부) — bit
  • HP_PDP_RegDate (정책 등록 일시) — DateTime

Member (HP_Member)

  • HP_M_Hp (전화번호) — Varchar(15) — Primary key — NOT NULL
  • HP_M_Name (이름) — Varchar(40) — NOT NULL
  • HP_M_Birth (생년월일) — Date — NOT NULL
  • HP_M_Gender (성별) — Varchar(1) — NOT NULL
  • HP_M_Email (이메일) — Varchar(50)
  • HP_M_Rdate (가입일자) — Date — NOT NULL
  • HP_M_Status (회원상태) — Bit — NOT NULL
  • HP_M_NickName (닉네임) — Varchar(20) — NOT NULL

Member (HP_OTP)

  • HP_O_Seq (일련번호) — INT — Primary key — NOT NULL
  • HP_M_Hp (전화번호) — Varchar(15) — Foreign key → Member.HP_M_Hp — NOT NULL
  • HP_O_Num (인증번호) — Varchar(6) — NOT NULL
  • HP_O_Sdate (전송시간) — DATETIME — NOT NULL
  • HP_O_Div (구분값) — char(01) — NOT NULL
  • HP_O_Sta (상태값) — Bit — NOT NULL

Product (HP_Product)

  • HP_P_Seq (상품 등록 번호) — INT — Primary key — NOT NULL
  • HP_P_Name (상품 이름) — Varchar(100) — NOT NULL
  • HP_P_Price (상품 가격) — Double — NOT NULL
  • HP_P_RegDate (상품 등록 일자) — DATETIME — NOT NULL
  • HP_P_StockLevel (상품 제고수량) — int — NOT NULL

Product (HP_Product_Image)

  • HP_PI_Seq (이미지 고유 번호) — INT — Primary key — NOT NULL
  • HP_P_Seq (상품 등록 번호) — INT — Foreign key → Product.HP_P_Seq — NOT NULL
  • HP_PI_Name (이미지 이름) — Varchar(40) — NOT NULL
  • HP_PI_Channel (이미지 경로) — URL(Varchar(2048)) — NOT NULL
  • HP_PI_FileExtension (이미지 확장자) — Varchar(40) — NOT NULL

Product (HP_Product_Detail)

  • HP_PD_DetailSeq (상품 상세 번호) — INT — Primary key — NOT NULL
  • HP_P_Seq (상품 등록 번호) — INT — Foreign key → Product.HP_P_Seq — NOT NULL
  • HP_PD_Html (상품 html 경로) — URL(Varchar(2048)) — NOT NULL

Product (HP_Product_Categore)

  • HP_PC_Code (카테고리 코드) — Varchar(40) — Primary key — NOT NULL
  • HP_P_Seq (상품 등록 번호) — INT — Foreign key → Product.HP_P_Seq — NOT NULL
  • HP_PC_Level (카테고리 단계) — INT — NOT NULL
  • HP_PC_Name (카테고리 이름) — Varchar(40) — NOT NULL

Product (HP_Product_ShopCart)

  • HP_PSC_Code (장바구니 상품 번호) — INT — Primary key — NOT NULL
  • HP_P_Seq (상품 등록 번호) — INT — Foreign key → Product.HP_P_Seq — NOT NULL
  • HP_M_Hp (전화번호) — Varchar(15) — Foreign key → Member.HP_M_Hp — NOT NULL
  • HP_PSC_Count (장바구니 상품 수량) — INT — NOT NULL
  • HP_PSC_RegDate (장바구니 등록 일시) — DATETIME — NOT NULL
  • HP_PSC_Sta (장바구니 상품 활성값) — Bit — NOT NULL

ProductOrder (HP_Product_Order)

  • HP_PO_Seq (주문 번호) — int — Primary key — NOT NULL
  • HP_M_Hp (전화번호2) — Varchar(15) — Foreign key → Member.HP_M_Hp — NOT NULL
  • HP_PDP_Seq (배송정책 번호) — int — Foreign key → DeliveryPolicy.HP_PDP_Seq — NOT NULL
  • HP_M_Hp (전화번호) — Varchar(15) — NOT NULL
  • HP_PO_RegDate (주문 일시) — DateTime — NOT NULL
  • HP_PO_Status (주문 상태) — int — NOT NULL
  • HP_PO_DeliveryType (주문 당시 배송 유형) — int — NOT NULL
  • HP_PO_DeliveryFee (주문 전체 베송비) — int — NOT NULL
  • HP_PO_DeliveryPayType (베송비 지불 구분) — int — NOT NULL
  • HP_PO_ProductAmount (상품 대금 합계) — int — NOT NULL

ProductOrder (HP_Product_Order_Detail)

  • HP_POD_Seq (주문 상품 상세 번호) — int — Primary key — NOT NULL
  • HP_PO_Seq (주문 번호2) — int — Foreign key → ProductOrder.HP_PO_Seq — NOT NULL
  • HP_M_Hp (전화번호2) — Varchar(15) — Foreign key → ProductOrder.HP_M_Hp — NOT NULL
  • HP_P_Seq (상품 등록 번호) — INT — Foreign key → Product.HP_P_Seq — NOT NULL
  • HP_PDP_Seq (배송정책 번호) — int — Foreign key → ProductOrder.HP_PDP_Seq — NOT NULL
  • HP_POD_ProductName (주문 당시 상품명) — varchar(100) — NOT NULL
  • HP_POD_UnitPrice (주문 당시 상품 단가) — int — NOT NULL
  • HP_POD_Quantity (주문 수량) — int — NOT NULL
  • HP_POD_ProductPayType (상품 대금 지불 구분) — Bit — NOT NULL