BOARD

Tables (6)

BOARD (board_table)

  • Bno — varchar2(20) — Primary key — NOT NULL
  • Member Id (member_id2) — varchar2(20) — Foreign key → MEMBER.Member Id — NOT NULL
  • Title — varchar2(200)
  • Content — clob
  • Writer — varchar2(20)
  • RegDate (Regdate) — date
  • Viewcnt — number
  • Show — char

MEMBER (member)

  • Member Id (member_id) — varchar2(20) — Primary key — NOT NULL
  • Member Name (member_name) — varchar2(20)
  • Member Pwd (member_pwd) — varchar2(512)
  • Member Wear (member_wear) — date
  • Member Date (member_daten) — date
  • Member Email (member_eail) — varchar2(40)
  • Member Phone (member_phone) — vrarchar2(20)
  • Member Seq (member_seq) — number
  • Member Zipcode (member_zipcode) — varchar2(20)
  • Member Faddr (member_faddrn) — varchar2(350)
  • Member Laddr (member_laddr) — varchar2(350)

PRODUCT (product)

  • Cate Id (cate_id) — varchar2(20) — Primary key — NOT NULL
  • Cate Name (cate_name) — varchar2(50)

PRODUCT_CART (product_cart)

  • Prd Id (prd_id) — varchar2(20) — Primary key — NOT NULL
  • Cart Id (cart_id) — date — Primary key
  • Member Id (member_id2) — varchar2(20) — Foreign key → MEMBER.Member Id — NOT NULL
  • Buy Quantity (buy_quantity) — date — NOT NULL
  • Prd Opt (prdd_opt) — varchar2(50)

PRODUCT_INFO (product_info)

  • Prd Id (prd_id) — varchar2(20) — Foreign key → PRODUCT_CART.Prd Id — NOT NULL
  • Cart Id (cart_id) — date — Foreign key → PRODUCT_CART.Cart Id
  • Member Id (member_id2) — varchar2(20) — Foreign key → PRODUCT_CART.Member Id — NOT NULL
  • Prd Date (prd_date) — date
  • Prd Name (prd_name) — varchar2(50)
  • Prd Price (prd_price) — number
  • Prd Img (prd_img) — varchar2(200)
  • Prd Delivery (prd_delivery) — number
  • Prd Stock (prd_stock) — number
  • Prd Option (prd_option) — varchar2(100)
  • Prd Discount (prd_discount) — number
  • Prd Explain (prd_explain) — varchar2(4000)

PRODUCT_PAYMENT (product_payment)

  • Payment Id (payment_id) — varchar2(50) — Primary key — NOT NULL
  • Member Id (member_id2) — varchar2(20) — Foreign key → PRODUCT_INFO.Member Id — NOT NULL
  • Prd Opt (prd_opt) — varchar2(200) — NOT NULL
  • Payment Date (payment_date) — varchar2(20)
  • Member Zipcode (member_zipcode) — number
  • Member Phone (member_phone) — varchar2(200)
  • Member Laddr (member_laddr) — varchar2(200)
  • Member_Faddr (member_faddr) — varchar2(100)
  • Delivery (delivery) — number
  • Credit Number (credit_number) — varchar2(4000)
  • Buy Quantity (buy_quantity) — varchar2(200)