NAVIYA
Tables (11)
tbl_authority
- au_id — NUMBER — Primary key
- u_id (u_id2) — NUMBER — Foreign key → tbl_users.u_id
- username — VARCHAR2(64)
- authority — VARCHAR2(50)
tbl_cart
- bk_id — NUMBER — Primary key
- bk_p_code — VARCHAR2(6) — NOT NULL
- bk_p_name — nVARCHAR2(255)
- username — VARCHAR2(64)
- bk_p_oprice — number
- bk_p_qty — number
- bk_p_status — nVARCHAR2(50)
- bk_p_buyTime — nVARCHAR2(50)
tbl_color
- c_code — number — Primary key
- c_s_code — number — Foreign key → tbl_size.s_code
- p_code (p_code2) — number — Foreign key → tbl_size.s_p_code
- c_color — nvarchar2(255)
- c_qty — number
tbl_p_images
- p_IMG_SEQ — NUMBER — Primary key
- p_IMG_P_CODE — number — Foreign key → tbl_product.p_code
- p_IMG_ORIGIN_NAME — nVARCHAR2(255)
- p_IMG_UPLOAD_NAME — nVARCHAR2(255)
tbl_product
- p_code — number — Primary key
- p_name — nVARCHAR2(255) — NOT NULL
- p_price — number
- p_desc — nVARCHAR2(1000)
- p_image — nVARCHAR2(255)
- p_size — nVARCHAR2(255)
- p_color — nVARCHAR2(255)
- p_qty — number
- p_total_price — number
tbl_q_a
- q_id — NUMBER — Primary key
- q_code — number — Foreign key → tbl_product.p_code
- q_title — nVARCHAR2(255)
- q_text — nVARCHAR2(1000)
- q_r_text — nVARCHAR2(1000)
- q_auth — VARCHAR2(64)
- q_date — VARCHAR2(40)
tbl_r_like
- r_id — NUMBER — Primary key
- r_id (r_id2) — NUMBER — Foreign key → tbl_review.r_id
- p_code — number — Foreign key → tbl_review.r_code
- r_like_username — VARCHAR2(64)
- r_review_id — NUMBER
tbl_review
- r_id — NUMBER — Primary key
- r_code — number — Foreign key → tbl_product.p_code
- r_text — nVARCHAR2(1000)
- r_star — int
- r_auth — VARCHAR2(64)
- r_date — VARCHAR2(40)
- r_image — VARCHAR2(255)
- r_like — NUMBER
tbl_review_images
- r_IMG_SEQ — NUMBER — Primary key
- r_id — NUMBER — Foreign key → tbl_review.r_id
- r_IMG_P_CODE — number — Foreign key → tbl_review.r_code
- r_IMG_ORIGIN_NAME — nVARCHAR2(255)
- r_IMG_UPLOAD_NAME — nVARCHAR2(255)
tbl_size
- s_code — number — Primary key
- s_p_code — number — Foreign key → tbl_product.p_code
- s_size — VARCHAR(255)
tbl_users
- u_id — NUMBER — Primary key
- username — VARCHAR2(64) — NOT NULL
- password — VARCHAR2(255) — NOT NULL
- email — VARCHAR2(255)
- address — nVARCHAR2(255)
- address_etc — nVARCHAR2(255)
- phone — VARCHAR2(20)
- enabled — number
- checkout — number
- account_non_expired — number
- account_non_locked — number
- credentials_non_expired — number