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)