OBAK
Tables (9)
ANSWER (답변)
- BOARD_SEQ (게시판번호) — Foreign key → Board.BOARD_SEQ — NOT NULL
- CONTENT (답변내용) — NOT NULL
- DEL_YN (삭제여부)
- INSERT_ID (등록자) — NOT NULL
- INSERT_DATE (등록일시) — NOT NULL
- MODIFY_ID (수정자) — NOT NULL
- MODIFY_DATE (수정일시) — NOT NULL
Board (게시판)
- BOARD_SEQ (게시판번호) — Primary key — NOT NULL
- BOARD_GB (게시판구분) — NOT NULL — 01:공지사항 / 02:QNA
- TITLE (제목) — NOT NULL
- CONTENT (내용) — NOT NULL
- ANSWER_YN (답변여부)
- INSERT_ID (등록자) — NOT NULL
- INSERT_DATE (등록일시) — NOT NULL
- MODIFY_ID (수정자) — NOT NULL
- MODIFY_DATE (수정일시) — NOT NULL
ExhibitDt (전시회Dt)
- exhibit_no (전시회No) — VARCHAR2(10) — Foreign key → ExhibitM.exhibit_no — NOT NULL
- exhibit_subtit (전시회부제목) — VARCHAR2(200) — NOT NULL
- sido (시도) — VARCHAR2(10) — NOT NULL
- gungu (군구) — VARCHAR2(10) — NOT NULL
- realm_code (전시회분류명) — VARCHAR2(10) — NOT NULL
- ticket_price (티켓요금) — Int(500) — NOT NULL
- url (관람URL) — VARCHAR2(300) — NOT NULL
- img_url (이미지URL) — VARCHAR2(300)
- place_url (공연장URL) — VARCHAR2(300)
- place_addr (공연장주소) — VARCHAR2(400)
- content1 (내용1) — VARCHAR2(4000) — NOT NULL
- content2 (내용2) — VARCHAR2(4000)
- gps_x (경도) — VARCHAR2(11)
- gps_y (위도) — VARCHAR2(11)
- insert_date (등록일자) — DATE — NOT NULL
- modify_date (수정일자) — DATE — NOT NULL
ExhibitM (전시회M)
- exhibit_no (전시회No) — VARCHAR2(10) — Primary key — NOT NULL
- exhibit_tit (전시회제목) — VARCHAR2(200) — NOT NULL
- realm_code (전시회분류코드) — VARCHAR2(4) — NOT NULL
- start_date (시작일자) — DATE — NOT NULL
- end_date (종료일자) — DATE — NOT NULL
- thumbnail_yn (썸네일여부) — VARCHAR2(1) — NOT NULL
- exhibit_place (장소) — VARCHAR2(50) — NOT NULL
- exhibit_area (지역) — VARCHAR2(10) — NOT NULL
- insert_date (등록일자) — DATE — NOT NULL
- modify_date (수정일자) — DATE — NOT NULL
FILE_MGMT (첨부파일)
- BOARD_SEQ (게시판번호) — Foreign key → Board.BOARD_SEQ — NOT NULL
- FILE_NAME (파일명) — NOT NULL
- FILE_EXT (확장자)
- FILE_PATH (파일경로)
- DEL_YN (삭제여부)
- INSERT_ID (등록자) — NOT NULL
- INSERT_DATE (등록일시) — NOT NULL
- MODIFY_ID (수정자) — NOT NULL
- MODIFY_DATE (수정일시) — NOT NULL
Favorite (즐겨찾는 전시회)
- user_no (사용자No) — VARCHAR2(12) — Foreign key → User.user_no — NOT NULL — 년월+시퀀스(ex.2308~)
- exhibit_no (전시회No) — VARCHAR2(10) — Foreign key → ExhibitM.exhibit_no — NOT NULL
- favorite_yn (즐겨찾기여부) — VARCHAR2(1) — NOT NULL
- insert_date (등록일자) — DATE — NOT NULL
- modify_date (수정일자) — DATE — NOT NULL
Notice (공지사항)
- notice_no (공지사항No) — VARCHAR2(10) — Primary key — NOT NULL
- user_no (사용자No) — VARCHAR2(12) — Foreign key → User.user_no — NOT NULL — 년월+시퀀스(ex.2308~)
- notice_gb (구분) — VARCHAR2(2) — NOT NULL — 게시판 구분(공지사항, FAQ)
- notice_tit (제목) — VARCHAR2(100) — NOT NULL
- notice_content (내용) — VARCHAR2(4000) — NOT NULL
- insert_id (등록자) — VARCHAR2(12) — NOT NULL
- insert_date (등록일자) — DATE — NOT NULL
- modify_id (수정자) — VARCHAR2(12) — NOT NULL
- modify_date (수정일자) — DATE — NOT NULL
Review (리뷰)
- review_no (리뷰No) — VARCHAR2(10) — Primary key — NOT NULL
- user_no (사용자No) — VARCHAR2(12) — Foreign key → User.user_no — NOT NULL — 년월+시퀀스(ex.2308~)
- exhibit_no (전시회No) — VARCHAR2(10) — NOT NULL
- content (리뷰내용) — VARCHAR2(400) — NOT NULL
- grade (평점) — int(10) — NOT NULL
- insert_date (등록일자) — DATE — NOT NULL
- modify_date (수정일자) — DATE — NOT NULL
User (회원)
- user_no (사용자No) — VARCHAR2(12) — Primary key — NOT NULL — 년월+시퀀스(ex.2308~)
- user_id (사용자ID) — VARCHAR2(100)
- user_name (사용자명) — VARCHAR2(20) — NOT NULL
- passwd (비밀번호) — VARCHAR2(50) — NOT NULL
- user_gb (사용자구분) — VARCHAR2(2) — (관리자, 일반 사용자)
- media_gb (가입매체) — VARCHAR2(2) — NOT NULL — 카카오톡 등 가입 매체 구분
- email (이메일) — VARCHAR2(50)
- phone_no (휴대폰번호) — VARCHAR2(20)
- insert_date (등록일자) — DATE — NOT NULL
- modify_date (수정일자) — DATE — NOT NULL