1. 테이블 이름 : board    (글)

<필드>

int idx;

String name;

String password;

String subject;

String content;

Date regDate;

String ip;

[오라클 SQL] (create sequence board_idx_seq는 mariaDB의 auto-increment용)

CREATE SEQUENCE board_idx_seq;   

CREATE TABLE board(

idx number primary key,

name varchar2(20) not null,

password varchar2(20) not null,

subject varchar2(100) not null,

content varchar2(1000) not null,

regdate timestamp default SYSDATE,

ip varchar2(30) not null

);

[MariaDB SQL]

CREATE TABLE board(

idx number primary key, auto_increment,

name varchar2(20) not null,

password varchar2(20) not null,

subject varchar2(100) not null,

content text not null,

regdate timestamp default now(),

ip varchar2(30) not null

);

2. 테이블 이름 : boardcomment    (댓글)

<필드>

int idx;

int ref;

String name;

String password;

String content;

Date regDate;

String ip;

[오라클 SQL]

CREATE SEQUENCE boardcomment_idx_seq;

CREATE TABLE boardcomment(

idx number primary key,

ref number not null,

name varchar2(20) not null,

password varchar2(20) not null,

content varchar2(1000) not null,

regdate timestamp default SYSDATE,

ip varchar2(30) not null

);

[MariaDB SQL]     ( default current_timestamp / default now() 대신에 쓸수있다함)

CREATE TABLE boardcomment(

idx number primary key, auto_increment,

ref number not null,

name varchar2(20) not null,

password varchar2(20) not null,

content text not null,

regdate timestamp default now(),

ip varchar2(30) not null

);

3. 테이블 이름 : boardfiles    (첨부파일)

<필드>

int idx;

int ref;

String oriname;

String convname;

[오라클 SQL]

CREATE SEQUENCE boardfiles_idx_seq;

CREATE TABLE boardfiles(

idx number primary key,

ref number not null,

oriname varchar2(100) not null,

convname varchar2(100) not null,

);

[MariaDB SQL]

CREATE TABLE boardfiles(

idx number primary key, auto_increment,

ref number not null,

oriname varchar2(100) not null,

convname varchar2(100) not null

);