SwingAndJDBCProject
Tables (8)
COMPANY_INFO (Untitled5)
- COMPANY_CODE (COMPANY_CODE_PK) — VARCHAR2(20) — Primary key — NOT NULL
- COMPANY_NAME (Field) — VARCHAR2(20) — NOT NULL
- COMPANY_TEL (Field2) — VARCHAR2(20) — NOT NULL
- COMPANY_EMAIL (Field3) — VARCHAR2(20) — NOT NULL
- COMPANY_ADDRESS (Field4) — VARCHAR2(20) — NOT NULL
- COMPANY_DESCRIPTION (Field5) — VARCHAR2(20) — NOT NULL
Copy Of SELL_PRODUCT (CopyOfUntitled6)
- IN_CODE (IN_CODE_PK) — VARCHAR2(20) — Primary key — NOT NULL
- PRODUCT_CODE (PRODUCT_CODE_PK) — VARCHAR2(20) — Foreign key → PRODUCT.PRODUCT_CODE — NOT NULL
- COMPANY_CODE (COMPANY_CODE_PK) — VARCHAR2(20) — Foreign key → COMPANY_INFO.COMPANY_CODE — NOT NULL
- IN_QUANTITY (Field) — NUMBER(10) — NOT NULL
- IN_AMOUNT (Field2) — NUMBER(10) — NOT NULL
- OUTPUT_DATE (Field3) — VARCHAR2(30) — NOT NULL
- IN_INFO (Field4) — VARCHAR(200) — NOT NULL
LARGE_CATEGORY (Untitled2)
- LARGE_CODE (LARGE_CODE_PK) — VARCHAR2(20) — Primary key — NOT NULL
- LARGE_CATEGORY (Field) — VARCHAR2(20) — NOT NULL
MEDIUM_CATEGORY (Untitled3)
- MEDIUM_CODE (MEDIUM_CODE_PK) — VARCHAR2(20) — Primary key — NOT NULL
- MEDIUM_CATEGORY (Field) — VARCHAR2(20) — NOT NULL
PRODUCT (Untitled)
- PRODUCT_CODE (PRODUCT_CODE_PK) — VARCHAR2(20) — Primary key — NOT NULL
- LARGE_CODE (LARGE_CODE_PK) — VARCHAR2(20) — Foreign key → LARGE_CATEGORY.LARGE_CODE — NOT NULL
- MEDIUM_CODE (MEDIUM_CODE_PK) — VARCHAR2(20) — Foreign key → MEDIUM_CATEGORY.MEDIUM_CODE — NOT NULL
- SMALL_CODE (SMALL_CODE_PK) — VARCHAR2(20) — Foreign key → SMALL_CATEGORY.SMALL_CODE — NOT NULL
- PRODUCT_NAME (Field) — VARCHAR2(20) — NOT NULL
- PRODUCT_PRICE (Field2) — NUMBER(10) — NOT NULL
- PRODUCT_STOCK (Field3) — NUMBER(10) — NOT NULL
- PRODUCT_EXPLAIN (Field4) — VARCHAR(200) — NOT NULL
- Field5
SELL_PRODUCT (Untitled6)
- SELL_CODE (SELL_CODE_PK) — VARCHAR2(20) — Primary key — NOT NULL
- PRODUCT_CODE (PRODUCT_CODE_PK) — VARCHAR2(20) — Foreign key → PRODUCT.PRODUCT_CODE — NOT NULL
- COMPANY_CODE (COMPANY_CODE_PK) — VARCHAR2(20) — Foreign key → COMPANY_INFO.COMPANY_CODE — NOT NULL
- SELL_QUANTITY (Field) — NUMBER(10) — NOT NULL
- SELL_AMOUNT (Field2) — NUMBER(10) — NOT NULL
- OUTPUT_DATE (Field3) — VARCHAR2(30) — NOT NULL
- SELL_INFO (Field4) — VARCHAR(200) — NOT NULL
SERIAL_NUM (Untitled7)
- SERIAL_NUM (Field) — VARCHAR2(20) — NOT NULL
SMALL_CATEGORY (Untitled4)
- SMALL_CODE (SMALL_CODE_PK) — VARCHAR2(20) — Primary key — NOT NULL
- Field