KITRI_Sportswear

Tables (8)

MEMBER (Untitled)

  • ID (member_id) — varchar2 — Primary key — NOT NULL
  • PWD (member_pw) — varchar2
  • NAME (member_name) — varchar2
  • EMAIL (member_email) — varchar2
  • ADDR (member_address) — varchar2
  • TYPE (member_type) — varchar2
  • POINT (member_point) — int

NOTICE (Untitled2)

  • NUM (notice_no) — int — Primary key — NOT NULL
  • TITLE (notice_title) — varchar2
  • CONTENT (notice_content) — CLOB
  • N_DATE (notice_ndate) — DATE
  • VIEW_COUNT (notice_viewcnt) — int

ODERINFO (Untitled3)

  • NUM (o_num) — int — Primary key — NOT NULL
  • OI_ID (oi_id) — varchar2
  • OI_NAME (oi_name) — varchar2
  • OI_PHONE (oi_phone) — varchar2
  • OI_EMAIL (oi_email) — varchar2
  • OI_ADDR_FULL (oi_addr_full) — varchar2
  • OI_ADDR_ZIPNO (oi_addr_zipno) — varchar2
  • OI_ADDR_ROADADDRPART1 (oi_addr_roadaddpart1) — varchar2
  • OI_ADDR_ROADADDRPART2 (oi_addr_roadaddrpart2) — varchar2
  • OI_ADDR_ADDRDETAIL (oi_addr_addrdetail) — varchar2
  • OI_DELIMESSAGE (oi_delimessage) — varchar2
  • OI_HOWPAY (oi_howpay) — varchar2
  • OI_USEPOINT (oi_usepoint) — int
  • OI_ORIGINTOTALPRICE (oi_origintotalprice) — int
  • OI_TOTALPRICE (oi_totalprice) — int
  • OI_ORDERDATE (oi_orderdate) — date
  • OI_CODENUM (oi_codenum) — varchar2

PRODUCT (Untitled4)

  • NUM (p_num) — int — Primary key — NOT NULL
  • NAME (p_name) — varchar2
  • PRICE (p_price) — int
  • IMG (p_img) — varchar2
  • CONTENT (p_content) — varchar2
  • E_DATE (p_edate) — date
  • RECORD (p_record) — int
  • CATEGORY (p_category) — varchar2

PRODUCT_IMAGE (Untitled5)

  • NUM (pi_num) — int — Primary key — NOT NULL
  • NUM (p_num) — int — Foreign key → PRODUCT.NUM — NOT NULL
  • IMG (pi_img) — varchar2

PRODUCT_ORDER (Untitled6)

  • NUM (o_num) — int — Primary key — NOT NULL
  • P_NUM (p_num) — int — Foreign key → PRODUCT.NUM — NOT NULL
  • M_ID (m_id) — varchar2 — Foreign key → MEMBER.ID — NOT NULL
  • O_QUANTITY (o_quantity) — int
  • TOTAL_PRICE (total_price) — int
  • O_DATE (o_date) — date
  • O_STATE (o_state) — int
  • D_STATE (d_state) — int
  • P_SIZE (p_size) — varchar2
  • R_STATE (r_state) — int
  • CODE_NUM (code_num) — varchar2

PRODUCT_SIZE (Untitled7)

  • NUM (s_num) — int — Primary key — NOT NULL
  • P_NUM (p_num) — int — Foreign key → PRODUCT.NUM — NOT NULL
  • PSIZE (psize) — varchar2
  • QUANTITY (quantity) — int

REVIEW (Untitled8)

  • NUM (r_num) — int — Primary key — NOT NULL
  • M_ID (m_id) — varchar2 — Foreign key → MEMBER.ID — NOT NULL
  • P_NUM (p_num) — int
  • RATE (r_rate) — double
  • CONTENT (r_content) — varchar2
  • IMG (r_img) — varchar2
  • R_DATE (r_date) — date