visitjeju

테이블 (10)

공지사항 (NOTICEBOARD)

  • Key (NOTICE_NO) — INT — 기본 키 — NOT NULL
  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field2 (TITLE) — VARCHAR(100)
  • Field3 (CONTENT) — VARCHAR(2000)
  • Field4 (ORIGINAL_FILENAME) — VARCHAR(1000)
  • Field (RENAMED_FILENAME) — VARCHAR(1000)
  • Field (STATUS) — VARCHAR(1) DEFAULT 'Y' CHECK (STATUS IN('Y', 'N'))
  • Field (CREATE_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (MODIFY_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP

비짓제주데이터 (CONTENT)

  • Field2 (CONTENTSID) — VARCHAR(100) UNIQUE — 기본 키
  • Field (ALLTAG) — VARCHAR(1000)
  • Field3 (TITLE) — VARCHAR(100)
  • Field4 (ADDRESS) — VARCHAR(100)
  • Field5 (ROADADDRESS) — VARCHAR(100)
  • Field6 (TAG) — VARCHAR(100)
  • Field7 (INTRODUCTION) — VARCHAR(1000)
  • Field (LATITUDE) — DOUBLE
  • Field (LONGITUDE) — DOUBLE
  • Field (POSTCODE) — VARCHAR(100)
  • Field (PHONENO) — VARCHAR(100)
  • Field (LIKEAMOUNT) — INT
  • Field (CONTENT_VALUE) — VARCHAR(100)
  • Field (CONTENT_LABEL) — VARCHAR(100)
  • Field (IMGPATH) — VARCHAR(1000)
  • Field (THUMBNAILPATH) — VARCHAR(1000)

사용자정보 (USER)

  • Key (USER_NO) — INT PRIMARY KEY AUTO_INCREMENT — 기본 키 — NOT NULL
  • Field (ID) — VARCHAR(100)
  • Field2 (PASSWORD) — VARCHAR(100)
  • Field3 (NICKNAME) — VARCHAR(100)
  • Field (EMAIL) — VARCHAR(1000)
  • Field (PHONE) — VARCHAR(100)
  • Field (KAKAOTOKEN) — VARCHAR(1000)
  • Field (STATUS) — VARCHAR(1) DEFAULT 'Y' CHECK(STATUS IN('Y', 'N'))
  • Field (ROLE) — VARCHAR(10) DEFAULT 'ROLE_USER'
  • Field (ENROLL_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field2 (MODIFY_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP

예약리스트 (RESERVATION_LIST)

  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field2 (CONTENTSID) — VARCHAR(100) — 외래 키 → 비짓제주데이터.Field2

자유게시판 (FREEBOARD)

  • Key (FREEBOARD_NO) — INT PRIMARY KEY AUTO_INCREMENT — 기본 키 — NOT NULL
  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field2 (TITLE) — VARCHAR(100)
  • Field3 (CONTENT) — VARCHAR(2000)
  • Field4 (ORIGINAL_FILENAME) — VARCHAR(1000)
  • Field (RENAMED_FILENAME) — VARCHAR(1000)
  • Field (READCOUNT) — INT
  • Field (STATUS) — VARCHAR(1) DEFAULT 'Y' CHECK (STATUS IN('Y', 'N'))
  • Field (CREATE_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (MODIFY_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (LIKEAMOUNT) — INT

자유게시판댓글 (FREEBOARD_REPLY)

  • Key (FREEBOARD_REPLY_NO) — INT PRIMARY KEY AUTO_INCREMENT — 기본 키 — NOT NULL
  • Key (FREEBOARD_NO) — INT — 외래 키 → 자유게시판.Key — NOT NULL
  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field (CONTENT) — VARCHAR(1000)
  • Field2 (STATUS) — VARCHAR(1) DEFAULT 'Y' CHECK (STATUS IN ('Y', 'N'))
  • Field (CREATE_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (MODIFY_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (LIKEAMOUNT) — INT

찜목록 (WANTLIST)

  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field2 (CONTENTSID) — VARCHAR(100) — 외래 키 → 비짓제주데이터.Field2

콘텐츠 댓글 (CONTENT_REPLY)

  • Key (CONTENT_REPLY_NO) — INT PRIMARY KEY AUTO_INCREMENT — 기본 키 — NOT NULL
  • Field2 (CONTENTSID) — VARCHAR(100) — 외래 키 → 비짓제주데이터.Field2
  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field (CONTENT) — VARCHAR(1000)
  • Field2 (STATUS) — VARCHAR(1) DEFAULT 'Y' CHECK (STATUS IN ('Y', 'N'))
  • Field (CREATE_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (MODIFY_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (LIKEAMOUNT) — INT

후기게시판 (REVIEWBOARD)

  • Key (REVIEWBOARD_NO) — INT PRIMARY KEY AUTO_INCREMENT — 기본 키 — NOT NULL
  • Field2 (CONTENTSID) — VARCHAR(100) — 외래 키 → 비짓제주데이터.Field2
  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field2 (TITLE) — VARCHAR(100)
  • Field3 (CONTENT) — VARCHAR(2000)
  • Field4 (ORIGINAL_FILENAME) — VARCHAR(1000)
  • Field (RENAMED_FILENAME) — VARCHAR(1000)
  • Field (READCOUNT) — INT
  • Field (STATUS) — VARCHAR(1) DEFAULT 'Y' CHECK (STATUS IN('Y', 'N'))
  • Field (CREATE_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (MODIFY_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (LIKEAMOUNT) — INT

후기게시판댓글 (REVIEWBOARD_REPLY)

  • Key (REVIEWBOARD_REPLY_NO) — INT PRIMARY KEY AUTO_INCREMENT — 기본 키 — NOT NULL
  • Key (REVIEWBOARD_NO) — INT — 외래 키 → 후기게시판.Key — NOT NULL
  • Key (USER_NO) — INT — 외래 키 → 사용자정보.Key — NOT NULL
  • Field (CONTENT) — VARCHAR(1000)
  • Field2 (STATUS) — VARCHAR(1) DEFAULT 'Y' CHECK (STATUS IN ('Y', 'N'))
  • Field (CREATE_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (MODIFY_DATE) — DATETIME DEFAULT CURRENT_TIMESTAMP
  • Field (LIKEAMOUNT) — INT