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