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