i go alone
Tables (12)
BOARD (Untitled6)
- BNO (게시글번호) — NUMBER(10) — Primary key — NOT NULL
- MEMNO (회원번호) — NUMBER(5) — Foreign key → P_MEMBER.MEMNO — NOT NULL
- TITLE (게시글제목) — VARCHAR2(50)
- WRITER (작성자) — VARCHAR2(100)
- REGDATE (게시일) — DATE
- STATUS (모드전환) — VARCHAR2(16)
- HITS (조회수) — NUMBER(4)
- SPOT (여행지) — VARCHAR2(30)
- UP (좋아요) — NUMBER(3)
FESTIVAL (Untitled3)
- FNAME (축제명) — VARCHAR2((20) — Primary key — NOT NULL
- LOCATION (위치) — VARCHAR2(30)
- FIMG (축제이미지) — VARCHAR2(100)
- FDATE (축제시작일) — DATE
- FDATE1 (축제마감일) — DATE
FRECOMMENT (Untitled11)
- F_BNO (댓글번호) — NUNBER(10) — Primary key — NOT NULL
- FBNO (게시글번호) — NUMBER(10) — Foreign key → FREEBOARD.FBNO — NOT NULL
- F_REGDATE (댓글등록일) — DATE
- F_CONTENTS (댓글내용) — CLOB
FREEBOARD (Untitled10)
- FBNO (게시글번호) — NUMBER(10) — Primary key — NOT NULL
- MEMNO (회원번호) — NUMBER(5) — Foreign key → P_MEMBER.MEMNO — NOT NULL
- FWRITER (작성자) — VARCHAR2(100)
- FCONTENTS (게시글내용) — CLOB
- FREGDATE (등록일) — DATE
- FSTATUS (모드전환) — VARCHAR2(14)
- FHITS (조회수) — NUMBER(2)
- FUP (좋아요) — NUMBER(3)
P_MEMBER (Untitled5)
- MEMNO (회원번호) — NUMBER(5) — Primary key — NOT NULL
- MID (아이디) — VARCHAR2(30)
- MPW (비밀번호) — VARCHAR2(30)
- MNAME (이름) — VARCHAR2(20)
- MBIRTH (생년월일) — VARCHAR2(2)
- MGENDER (성별) — VARCHAR2(2)
- MHP (휴대폰번호) — VARCHAR2(20)
- MEMAIL (이메일) — VARCHAR2(
P_ORDER (Untitled4)
- ONO (주문번호) — NUMBER(5) — Primary key — NOT NULL
- MEMNO (회원번호) — NUMBER(5) — Foreign key → P_MEMBER.MEMNO — NOT NULL
- PNO (상품번호) — NUMBER(3) — Foreign key → TRIP.PNO — NOT NULL
- ODATE (주문날짜) — DATE
- PNAME (상품명) — VARCHAR2(100)
- PPRICE (상품가격) — NUMBER(10)
- STATUS (결제상태) — VARCHAR2(50)
- TDATE (여행날짜) — DATE
QNABOARD (Untitled12)
- BNO (게시글번호) — NUMBER(10) — Primary key — NOT NULL
- MEMNO (회원번호) — NUMBER(5) — Foreign key → P_MEMBER.MEMNO — NOT NULL
- BTITLE (게시글제목) — VARCHAR2(30)
- MNAME (회원명) — VARCHAR2(100)
- MCONTENTS (게시글내용) — CLOB
- BREFDATE (게시일) — DATE
- BHITS (조회수) — NUMBER(3)
- BPASSWORD (게시글비번) — VARCHAR2(20)
RECOMMENT (Untitled7)
- RE_BNO (댓글번호) — NUMBER(30) — Primary key — NOT NULL
- BNO (게시글번호) — NUMBER(10) — Foreign key → BOARD.BNO — NOT NULL
- WRITER (작성자) — VARCHAR2(100)
- RE_REGDATE (댓글등록일) — DATE
- RE_CONTENTS (댓글내용) — CLOB
THEMA (Untitled)
- TNO (테마번호) — NUMBER(2) — Primary key — NOT NULL
- TNAME (테마명) — VARCHAR2(50)
TOGETHER (Untitled8)
- TBNUM (게시글번호) — NUMBER(3) — Primary key — NOT NULL
- MEMNO (회원번호) — NUMBER(5) — Foreign key → P_MEMBER.MEMNO — NOT NULL
- TBTITLE (게시글제목) — VARCHAR2(30)
- TBHEART (추천) — NUMBER(3)
- TBSTATUS (동행완료여부) — NUMBER(1)
- TBID (회원아이디) — VARCHAR2(100)
- TBCONTENTS (게시글내용) — CLOB
- TBSCHEDULE (여행일정) — VARCHAR2(100)
- TBSPOT (동행장소) — VARCHAR2(100)
- TBTHEMA (테마명) — VARCHAR2(50)
- TBPRODUCT (상품명) — VARCHAR2(100)
- TBAGE (나이제한) — VARCHAR2(100)
- TBGENDER (성별제한) — VARCHAR2(50)
- TBREGDATE (여행일) — DATE
- TBSTATUS (모드전환) — VARCHAR2(16)
- TBHITS (조회수) — NUMBER(2)
TOGETHER_RECOMMENT (Untitled9)
- T_BNO (댓글번호) — NUMBER(10) — Primary key — NOT NULL
- TBNUM (게시글번호) — NUMBER(3) — Foreign key → TOGETHER.TBNUM — NOT NULL
- T_WRITER (작성자) — VARCHAR2(100)
- T_REGDATE (댓글등록일) — DATE
- T_CONTENTS (댓글내용) — CLOB
TRIP (Untitled2)
- PNO (상품번호) — NUMBER(3) — Primary key — NOT NULL
- TNO (테마번호) — NUMBER(2) — Foreign key → THEMA.TNO — NOT NULL
- TNAME (테마명) — VARCHAR2(50)
- PNAME (상품명) — VARCHAR2(100)
- PPRICE (상품가격) — NUMBER(10)
- QTY (제한인원) — NUMBER(2)
- PCONTENTS (상품요약내용) — VARCHAR2(100)
- MAINIMG (메인이미지) — VARCHAR2(100)
- DETAILIMG (상세이미지) — VARCHAR2(100)
- COURSE (코스) — VARCHAR2(200)