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