📄 create.sql
字号:
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) );
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -