해수욕장 추천 - 바다가다

테이블 (12)

article

  • id — INT(10) — 기본 키 — NOT NULL
  • boardId — INT(10) — 외래 키 → board.id — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • title — CHAR(100) — NOT NULL
  • body — TEXT — NOT NULL
  • goodReactionPoint — INT(10) — NOT NULL
  • badReactionPoint — INT(10) — NOT NULL
  • memberId — INT(10)

board

  • id — INT(10) — 기본 키 — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • code — CHAR(50) — NOT NULL — notice(공지사항), beachRecommend(바다추천), qna(질의응답), ....
  • name — CHAR(20) — NOT NULL — 게시판 이름
  • delStatus — TINYINT(1) — NOT NULL — 삭제 여부 (0=삭제 전, 1=삭제 후)
  • delDate — DATETIME — 삭제 날짜

chat

  • id — INT(11) — 기본 키 — NOT NULL
  • memberId — INT(10) — 외래 키 → member.id — NOT NULL
  • type — VARCHAR(255) — NOT NULL
  • roomId — INT(10) — NOT NULL
  • sender — VARCHAR(255) — NOT NULL
  • message — VARCHAR(255) — NOT NULL
  • time — TIMESTAMP

chatRoom

  • id — INT(11) — 기본 키 — NOT NULL
  • memberId — INT(10) — 외래 키 → member.id — NOT NULL
  • roomName — VARCHAR(255) — NOT NULL

chat_user

  • id — INT(10) — 기본 키 — NOT NULL
  • memberId — INT(10) — 외래 키 → member.id — NOT NULL
  • roomId — INT(10) — NOT NULL

genFile

  • id — INT(10) — 기본 키 — NOT NULL
  • relId — INT(10) — 외래 키 → article.id — NOT NULL
  • id (id2) — INT(10) — 외래 키 → article.boardId — NOT NULL
  • regDate — DATETIME
  • updateDate — DATETIME
  • delDate — DATETIME
  • delStatus — TINYINT(1)
  • relTypeCode — CHAR(50)
  • originFileName — VARCHAR(100)
  • fileExt — CHAR(10)
  • typeCode — CHAR(20)
  • type2Code — CHAR(20)
  • fileSize — INT(10)
  • fileExtTypeCode — CHAR(10)
  • fileNo — SMALLINT(2)
  • fileDir — CHAR(20)

member

  • id — INT(10) — 기본 키 — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • loginId — CHAR(20) — NOT NULL
  • loginPw — CHAR(100) — NOT NULL
  • authLevel — SMALLINT(2) — 권한 레벨 (3=일반,7=관리자)
  • name — CHAR(20) — NOT NULL
  • nickname — CHAR(20) — NOT NULL
  • cellphoneNum — CHAR(20) — NOT NULL
  • email — CHAR(50) — NOT NULL
  • delStatus — TINYINT(1) — NOT NULL — 탈퇴 여부 (0=탈퇴 전, 1=탈퇴 후)
  • delDate — DATETIME — 탈퇴 날짜
  • lockedTime — DATETIME
  • failCount — INT(10) — NOT NULL
  • isAccountLocked — TINYINT(1) — NOT NULL

reactionPoint

  • id — INT(10) — 기본 키 — NOT NULL
  • relId (relId2) — INT(10) — 외래 키 → reply.relId — NOT NULL
  • memberId — INT(10) — 외래 키 → reply.memberId — NOT NULL
  • id (id2) — INT(10) — 외래 키 → reply.id — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • relTypeCode — CHAR(50) — NOT NULL — 관련 데이터 타입 코드
  • relId — INT(10) — NOT NULL — 관련 데이터 번호
  • point — INT(10) — NOT NULL

reply

  • id — INT(10) — 기본 키 — NOT NULL
  • relId — INT(10) — 외래 키 → article.id — NOT NULL
  • memberId — INT(10) — 외래 키 → member.id — NOT NULL
  • id (id2) — INT(10) — 외래 키 → article.boardId — NOT NULL
  • regDate — DATETIME — NOT NULL
  • updateDate — DATETIME — NOT NULL
  • relTypeCode — CHAR(50) — NOT NULL — 관련 데이터 타입 코드
  • bodyTEXT — NOT — NOT NULL
  • goodReactionPoint — INT(10) — NOT NULL

schedule

  • schedule_idx — INT(11) — 기본 키 — NOT NULL
  • memberId — INT(10) — 외래 키 → member.id — NOT NULL
  • schedule_num — INT(11)
  • schedule_subject — VARCHAR(45)
  • schedule_desc — VARCHAR(45)
  • schedule_startdate — DATE
  • schedule_enddate — DATE
  • color — VARCHAR(45)

tb_weather_area

  • areacode — VARCHAR(50) — NOT NULL — 행정구역코드' COLLATE 'utf8_general_ci
  • step1 — VARCHAR(50) — NOT NULL — 시도' COLLATE 'utf8_general_ci
  • step2 — VARCHAR(50) — 시군구' COLLATE 'utf8_general_ci
  • step3 — VARCHAR(50) — 읍면동' COLLATE 'utf8_general_ci
  • gridX — VARCHAR(50) — NOT NULL — 격자X' COLLATE 'utf8_general_ci
  • gridY — VARCHAR(50) — NOT NULL — 격자Y' COLLATE 'utf8_general_ci
  • longitudeHour — VARCHAR(50) — NOT NULL — 경도(시)' COLLATE 'utf8_general_ci
  • longitudeMin — VARCHAR(50) — NOT NULL — 경도(분)' COLLATE 'utf8_general_ci
  • longitudeSec — VARCHAR(50) — 경도(초)' COLLATE 'utf8_general_ci
  • latitudeHour — VARCHAR(50) — NOT NULL — 위도(시)' COLLATE 'utf8_general_ci
  • latitudeMin — VARCHAR(50) — NOT NULL — 위도(분)' COLLATE 'utf8_general_ci
  • latitudeSec — VARCHAR(50) — NOT NULL — 위도(초)' COLLATE 'utf8_general_ci
  • longitudeMs — VARCHAR(50) — NOT NULL — 경도(초/100)' COLLATE 'utf8_general_ci
  • latitudeMs — VARCHAR(50) — NOT NULL — 위도(초/100)' COLLATE 'utf8_general_ci

tw_weather_response

  • baseDate — VARCHAR(50) — NOT NULL — 발표일자' COLLATE 'utf8_general_ci
  • baseTime — VARCHAR(50) — NOT NULL — 발표시각' COLLATE 'utf8_general_ci
  • category — VARCHAR(50) — NOT NULL — 자료구분코드' COLLATE 'utf8_general_ci
  • nx — VARCHAR(50) — NOT NULL — 예보지점X좌표' COLLATE 'utf8_general_ci
  • ny — VARCHAR(50) — NOT NULL — 예보지점Y좌표' COLLATE 'utf8_general_ci
  • obsrValue — VARCHAR(50) — NOT NULL — 실황 값' COLLATE 'utf8_general_ci