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