CREATE TABLE blog
(
no NUMBER(11) NOT NULL,
id VARCHAR2(30),
img VARCHAR2(100),
about VARCHAR2(2000),
regdate DATE NOT NULL,
CONSTRAINT "BLOG_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE blog_category
(
no NUMBER(11) NOT NULL,
blog_no NUMBER(11) NOT NULL,
contents VARCHAR2(100),
regdate DATE NOT NULL,
CONSTRAINT "BLOG_CATEGORY_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE blog_board
(
no NUMBER(11) NOT NULL,
blog_category_no NUMBER(11) NOT NULL,
title VARCHAR2(100),
contents CLOB,
hit NUMBER(11),
regdate DATE NOT NULL,
CONSTRAINT "BLOG_BOARD_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE product
(
no NUMBER(11) NOT NULL,
product_name VARCHAR2(100) NOT NULL,
price NUMBER NOT NULL,
production VARCHAR2(100),
authentication VARCHAR2(100),
shipping VARCHAR2(100),
regdate DATE NOT NULL,
CONSTRAINT "PRODUCT_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE product_image
(
no NUMBER(11) NOT NULL,
product_no NUMBER(11) NOT NULL,
img VARCHAR2(100) NOT NULL,
regdate DATE NOT NULL,
CONSTRAINT "PRODUCT_IMAGE_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE membership
(
no NUMBER(11) NOT NULL,
id VARCHAR2(30) NOT NULL,
name VARCHAR2(100) NOT NULL,
password VARCHAR2(30) NOT NULL,
phone VARCHAR2(20) NOT NULL,
birthday DATE,
nickname VARCHAR2(100),
post CHAR(7 BYTE) NOT NULL,
addr1 VARCHAR2(150),
addr2 VARCHAR2(200),
email VARCHAR2(50),
regdate DATE NOT NULL,
CONSTRAINT "MEMBERSHIP_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE reserve_state
(
code VARCHAR2(4) NOT NULL,
contents VARCHAR2(50),
regdate DATE NOT NULL,
CONSTRAINT "RESERVE_STATE_PK" PRIMARY KEY ("CODE") ENABLE
)
;
CREATE TABLE reserve
(
no NUMBER(11) NOT NULL,
reserve_state_code VARCHAR2(4) NOT NULL,
product_no NUMBER(11) NOT NULL,
count NUMBER(3) NOT NULL,
item_price NUMBER(11),
regdate DATE NOT NULL,
CONSTRAINT "RESERVE_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE "BOARD"
( "NO" NUMBER(11,0) NOT NULL ENABLE,
"GROUP_NO" NUMBER(11,0) NOT NULL ENABLE,
"ORDER_NO" NUMBER(11,0) NOT NULL ENABLE,
"DEPTH_NO" NUMBER(11,0) NOT NULL ENABLE,
"ID" VARCHAR2(30),
"TITLE" VARCHAR2(100),
"WRITER" VARCHAR2(50),
"CONTENTS" CLOB,
"HIT" NUMBER(11,0),
"TYPE" VARCHAR2(50),
"REGDATE" DATE NOT NULL ENABLE,
CONSTRAINT "BOARD_PK" PRIMARY KEY ("NO") ENABLE
);
CREATE TABLE board_comment
(
no NUMBER(11) NOT NULL,
board_no NUMBER(11) NOT NULL,
id VARCHAR2(30),
writer VARCHAR2(50),
contents VARCHAR2(2000),
regdate DATE,
CONSTRAINT "BOARD_COMMENT_PK" PRIMARY KEY ("NO") ENABLE
)
;
CREATE TABLE blog_comment
(
no NUMBER(11) NOT NULL,
blog_board_no NUMBER(11) NOT NULL,
writer VARCHAR2(50),
contents VARCHAR2(2000),
regdate DATE NOT NULL,
CONSTRAINT "BLOG_COMMENT_PK" PRIMARY KEY ("NO") ENABLE
)
;
create sequence board_seq;
create sequence board_comment_seq;
create sequence member_seq;
