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