프로젝트 테스트
테이블 (4)
board
- idx (board_idx) — number — 기본 키 — NOT NULL
- idx (user_idx) — number — 외래 키 → user_information.idx — NOT NULL
- Field2 (subject) — varchar2(100)
- Field3 (content) — varchar2(5000)
- Field4 (address) — varchar2(200)
- Field5 (pay) — number
- Field (category) — varchar2(20)
- Field (regDate) — date
- Field (clickCount) — number
- Field (likeCount) — number
- Field (commentCount) — number
comment
- Key (comment_idx) — number — 기본 키 — NOT NULL
- idx (board_idx) — number — 외래 키 → board.idx — NOT NULL
- idx (user_idx) — number — 외래 키 → board.idx — NOT NULL
- Field (content) — varchar2(150)
- Field2 (regDate) — date
- Field (category) — varchar2(20)
image
- Key (image_idx) — number — 기본 키 — NOT NULL
- idx (board_idx) — number — 외래 키 → board.idx — NOT NULL
- idx (user_idx) — number — 외래 키 → board.idx — NOT NULL
- Field (ofileName) — varchar2(100)
- Field (sfileName) — varchar2(100)
user_information
- idx (user_idx) — number — 기본 키 — NOT NULL
- id — varchar2(50)
- password — varchar2(50)
- name — varchar2(50)
- birth — date
- gender — char(1)
- email — varchar2(50)
- phone — varchar2(20)
- postcode (postCode) — varchar2(10)
- addr1 — varchar2(200)
- addr2 — varchar2(200)
- use — number
- lev — number
- point — number