The-Hyundai

Tables (8)

tb_pd_user (사용자 테이블)

  • user_id (Key) — serial4 — Primary key — NOT NULL
  • login_id (Field) — varchar(20)
  • password (Field2) — varchar(20)
  • user_nm (Field3) — varchar(10)
  • birth_dt (Field4) — varchar(8)
  • user_mobno (Field5) — varchar(20)
  • user_email (Field6) — varchar(30)
  • privacy_agree_yn (Field7) — varchar(1)
  • usage_agree_yn (Field8) — varchar(1)
  • user_type_cd (Field9) — varchar(10)
  • reg_dtm (Field10) — timestamp

tb_prod_delivery_company (배송회사명)

    tb_prod_delivery_condition (배송정책)

      tb_prod_order (주문 테이블)

      • order_id (Key) — serial4 — Primary key — NOT NULL
      • user_id (Key2) — integer — Foreign key → tb_pd_user.user_id — NOT NULL
      • product_id (Key3) — integer — Foreign key → tb_prod_product.product_id — NOT NULL
      • option_id (Key4) — integer — Foreign key → tb_prod_product_option.option_id — NOT NULL
      • product_id (Key22) — serial4 — Foreign key → tb_prod_product_option.product_id — NOT NULL
      • user_id (Key23) — serial4 — Foreign key → tb_prod_product.user_id — NOT NULL
      • count (Key5) — integer
      • reg_dtm (Field) — timestamp
      • delivery_zipcode (Field2) — varchar
      • delivery_addr (Field3) — varchar
      • receiver_nm (Field4) — varchar
      • order_request (Field5) — varchar
      • order_st_cd (Field6) — varchar
      • prev_order_st_cd (Field13) — varchar
      • order_st_upd_id (Field24) — integer
      • order_st_upd_dtm (Field23) — timestamp
      • total_cost (Field7) — integer
      • merchant_uid (Field8) — varchar
      • payment_cd (Field9) — varchar(1)
      • vbank_valid_dtm (Field10) — timestamp
      • vbank_account (Field11) — varchar
      • vbank_name (Field12) — varchar
      • delivery_num (Field21) — varchar
      • delivery_com_nm (Field20) — varchar
      • purchase_confirm_dtm (Field22) — timestamp
      • cancel_user_id (Field14) — integer
      • cancel_rsn (Field15) — varchar
      • cancel_req_dtm (Field16) — timestamp
      • cancel_bank_account (Field17) — varchar
      • cancel_bank_name (Field18) — varchar
      • cancel_bank_holder_name (Field19) — varchar

      tb_prod_prod_file (상품 썸네일 테이블)

      • file_id (Key2) — Primary key — NOT NULL
      • product_id (Key) — serial4 — Foreign key → tb_prod_product.product_id — NOT NULL
      • file_nm (Field) — varchar
      • file_url (Field2) — varchar

      tb_prod_product (상품 테이블)

      • product_id (Key) — serial4 — Primary key — NOT NULL
      • user_id (Key2) — integer — Foreign key → tb_pd_user.user_id — NOT NULL
      • product_nm (Field) — varchar
      • model_nm (Field2) — varchar
      • price (Field3) — integer
      • price_discount (Field4) — integer
      • price_supply (Field8) — integer
      • sell_yn (Field5) — varchar
      • delivery_condition_id (Field6) — integer
      • content (Field7) — varchar
      • banner (Field10) — varchar
      • reg_dtm (Field9) — timestamp

      tb_prod_product_option (옵션 테이블)

      • option_id (Key) — serial4 — Primary key — NOT NULL
      • product_id (Key2) — serial4 — Foreign key → tb_prod_product.product_id — NOT NULL
      • option_nm (Field) — varchar
      • price (Field2) — integer
      • price_supply (Field3) — integer
      • stock (Field4) — integer
      • use_yn (Field5) — varchar

      tb_sys_comn_cd (커먼코드 테이블)