create.sql

来自「一个个人知识在线系统」· SQL 代码 · 共 35 行

CREATE DATABASE ch03;

# -----------------------------------------------------------------------
# category
# -----------------------------------------------------------------------
drop table if exists category;

CREATE TABLE CATEGORY (
CATEGORY_CD   CHAR(2)     NOT NULL,
CATEGORY_NAME VARCHAR(20) NOT NULL,
PRIMARY KEY (CATEGORY_CD) );

# -----------------------------------------------------------------------
# sub_category
# -----------------------------------------------------------------------
drop table if exists sub_category;

CREATE TABLE SUB_CATEGORY (
CATEGORY_CD       CHAR(2)     NOT NULL,
SUB_CATEGORY_CD   CHAR(2)     NOT NULL,
SUB_CATEGORY_NAME VARCHAR(20) NOT NULL,
PRIMARY KEY (CATEGORY_CD, SUB_CATEGORY_CD) );

# -----------------------------------------------------------------------
# tip
# -----------------------------------------------------------------------
drop table if exists tip;

CREATE TABLE TIP (
TIP_CD          CHAR(8)       NOT NULL,
CATEGORY_CD     CHAR(2)       NOT NULL,
SUB_CATEGORY_CD CHAR(2)       NOT NULL,
TIP_TITLE       VARCHAR(90)   NOT NULL,
TIP_CONTENT     TEXT ,
PRIMARY KEY (TIP_CD) );