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 (커먼코드 테이블)