목록Back-end/Team Project (3)

이안의 평일코딩

프로젝트3차 -1 sql + 데이터긁기

CREATE TABLE park_reply( no NUMBER, --댓글번호 bno NUMBER NOT NULL, --글번호 name VARCHAR2(100), id VARCHAR2(20) NOT NULL, --글쓴이아이디 msg CLOB NOT NULL, --댓글내용 regdate DATE DEFAULT SYSDATE, --댓글작성일시 group_id NUMBER, group_step NUMBER DEFAULT 0, group_tab NUMBER DEFAULT 0, root NUMBER DEFAULT 0, depth NUMBER DEFAULT 0 ); CREATE TABLE dog_board_reply1( no NUMBER, --댓글번호 bno NUMBER NOT NULL, --글번호 id VARCHA..
Back-end/Team Project 2020. 11. 18. 19:16
국비 Spring 프로젝트 DB설계 및 화면UI

#7 반려동물 산책코스 DB설계 app.diagrams.net/ Flowchart Maker & Online Diagram Software Flowchart Maker and Online Diagram Software diagrams.net (formerly draw.io) is free online diagram software. You can use it as a flowchart maker, network diagram software, to create UML online, as an ER diagram tool, to design database schema, to build BPM app.diagrams.net dog => 산책코스 리스트, 디테일 CREATE TABLE dog( no NUMB..
Back-end/Team Project 2020. 11. 15. 22:20
2차 프로젝트

1. db테이블 생성 뉴스 news n_no NUMBER N-N n_title VARCHAR2(1000) N-N n_poster VARCHAR2(1000) N-N n_regdate VARCHAR2(500) N-N n_precontent VARCHAR2(2000) N-N n_content CLOB N-N n_writer VARCHAR2(500) N-N n_hit NUMBER N-N n_tag VARCHAR2(500) NULL n_cno NUMBER NULL n_comment CLOB NULL n_id VARCHAR2(500) NULL n_pwd VARCHAR2(500) NULL 비디오 video v_no NUMBER N-N v_title VARCHAR2(1000) N-N v_video VARCHAR2(10..
Back-end/Team Project 2020. 10. 16. 15:08
Prev 1 Next