페이지 모듈화를 위한 Tiles

▶️ 게시판

NOTICE TABLE

create table notice(
    bo_no number(8) not null,
    bo_title varchar2(300) not null,
    bo_content varchar2(4000) not null,
    bo_writer varchar2(150) not null,
    bo_date date not null,
    bo_hit number(8) default 0 null,
    constraint pk_notice primary key(bo_no)
);

create sequence seq_notice increment by 1 start with 1 nocache;

create table noticefile(
    file_no number(8) not null,
    bo_no number(8) not null,
    file_name varchar2(300) not null,
    file_size number(20) not null,
    file_fancysize varchar2(100) not null,
    file_mime varchar2(100) not null,
    file_savepath varchar2(500) not null,
    file_downcount number(8) not null,
    constraint pk_noticefile primary key(file_no),
    constraint fk_noticefile_bo_no foreign key(bo_no)
        references notice(bo_no)
);
create sequence seq_noticefile increment by 1 start with 1 nocache;

NoticeFileVO
NoticeVO

공지사항 등록하기 (CKEDITOR 파일처리)

공지사항 등록하기 telegram 알람