여행후기

테이블 (4)

attach

  • uuid — varchar2(100)
  • uploadPath — varchar2(200) — NOT NULL
  • fileName — varchar2(200) — NOT NULL
  • fileType — char(1)
  • bno — number(10,0)

board

  • bno — number(10,0)
  • title — varchar2(200) — NOT NULL
  • imageFileName — varchar2(1000)
  • regDate — timestamp(3)
  • updateDate — timestamp(3)
  • viewCount — number(10,0)
  • memberId — varchar2(50) — NOT NULL

member

  • memberId — varchar2(50) — NOT NULL
  • memberPw — varchar2(50) — NOT NULL
  • memberName — varchar2(100) — NOT NULL
  • memberEmail — varchar2(100) — NOT NULL
  • memberPhoneNumber — varchar2(100) — NOT NULL
  • joinDate — date

reply

  • rno — number(10,0)
  • replyContent — varchar2(4000) — NOT NULL
  • replyDate — timestamp(0)
  • updateDate — timestamp(0)
  • memberId — varchar2(50) — NOT NULL
  • bno — number(10) — NOT NULL