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