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)