[DB作成]
[SQL]
CREATE DATABASE PARTS_VIEW;
[/SQL]
[テーブル1]
[SQL]
CREATE TABLE PARTS_PICT(
PO_NO VARCHAR(30) NOT NULL,
PO_PICT VARCHAR(100),
PRIMARY KEY (PO_NO))
type=InnoDB;
[/SQL]
[テーブル2]
[SQL]
CREATE TABLE PARTS_INFO(
PO_NO VARCHAR(30) NOT NULL,
SUP_NO VARCHAR(100),
SUP_NAME VARCHAR(100),
SUP_CONTACT VARCHAR(20),
PRIMARY KEY (PO_NO))
type=InnoDB;
[/SQL]
