onGoing

Tables (7)

O_BOARD (게시판)

  • B_ID (게시글번호) — NUMBER — Primary key — NOT NULL
  • E_ID (전시번호) — NUMBER — Foreign key → O_EXHIBITION.E_ID — NOT NULL
  • M_ID (회원번호) — VARCHAR2(20) — Foreign key → O_MEMEBER.M_ID — NOT NULL
  • B_TITLE (제목) — VARCHAR2(50) — NOT NULL
  • B_CONTENT (내용) — VARCHAR2(300) — NOT NULL
  • B_REGDATE (생성일시) — DATE — NOT NULL
  • B_UPDATEDATE (수정일시) — DATE — NOT NULL

O_COMMENT (댓글)

  • C_ID (댓글번호) — NUMBER — Primary key — NOT NULL
  • B_ID (게시글번호) — NUMBER — Foreign key → O_BOARD.B_ID — NOT NULL
  • E_ID (전시번호) — NUMBER — Foreign key → O_BOARD.E_ID — NOT NULL
  • M_ID (회원번호) — VARCHAR2(20) — Foreign key → O_BOARD.M_ID — NOT NULL
  • M_ID (회원번호2) — VARCHAR2(20) — Foreign key → O_MEMEBER.M_ID — NOT NULL
  • C_PID (부모번호) — NUMBER — NOT NULL
  • C_CONTENT (내용) — VARCHAR2(100) — NOT NULL
  • C_REGDATE (생성일시) — DATE — NOT NULL
  • C_UPDATEDATE (수정일시) — DATE — NOT NULL

O_EXHIBITION (전시)

  • E_ID (전시번호) — NUMBER — Primary key — NOT NULL
  • E_NAME (전시명) — VARCHAR2(50) — NOT NULL
  • E_PLACE (전시장소) — VARCHAR2(20) — NOT NULL
  • E_DETAIL (상세설명) — VARCHAR2(500) — NOT NULL
  • E_SIZE (최대수용인원) — NUMBER — NOT NULL
  • E_LIKE (찜) — NUMBER — NOT NULL
  • E_STARTDATE (시작일시) — VARCHAR2(20) — NOT NULL
  • E_ENDDATE (마감일시) — VARCHAR2(20) — NOT NULL
  • E_REGDATE (생성일자) — DATE — NOT NULL
  • E_UPDATEDATE (수정일자) — DATE

O_LIKE (찜)

  • L_ID (찜번호) — NUMBER — Primary key — NOT NULL
  • M_ID (회원번호) — VARCHAR2(20) — Foreign key → O_MEMEBER.M_ID — NOT NULL
  • E_ID (전시번호) — NUMBER — Foreign key → O_EXHIBITION.E_ID — NOT NULL

O_MEMEBER (회원)

  • M_ID (회원번호) — VARCHAR2(20) — Primary key — NOT NULL
  • M_PW (비밀번호) — VARCHAR2(100) — NOT NULL
  • M_NAME (이름) — VARCHAR2(20) — NOT NULL
  • M_NICKNAME (닉네임) — VARCHAR2(20) — NOT NULL
  • M_EMAIL (이메일) — VARCHAR2(50) — NOT NULL
  • M_REGDATE (생성일자) — DATE — NOT NULL

O_NOTICE (공지사항)

  • N_ID (공지사항번호) — NUMBER — Primary key — NOT NULL
  • N_TITLE (제목) — VARCHAR2(50) — NOT NULL
  • N_CONTENT (내용) — VARCHAR2(300) — NOT NULL
  • N_REGDATE (생성일시) — DATE — NOT NULL
  • N_UPDATEDATE (수정일시) — DATE — NOT NULL

O_TICKET (예매)

  • T_ID (예매번호) — NUMBER — Primary key — NOT NULL
  • E_ID (전시번호) — NUMBER — Foreign key → O_EXHIBITION.E_ID — NOT NULL
  • M_ID (회원번호) — VARCHAR2(20) — Foreign key → O_MEMEBER.M_ID — NOT NULL
  • T_DATE (예매일) — VARCHAR2(10) — NOT NULL
  • T_TIME (예매시간) — NUMBER — NOT NULL
  • T_SIZE (예매인원) — NUMBER — NOT NULL
  • T_RATE (평점) — NUMBER
  • T_REGDATE (생성일자) — DATE — NOT NULL