ㅁㄴㅇㄹ

테이블 (7)

멤버쉽 (Untitled3)

  • memberId — pk — 기본 키 — NOT NULL
  • memberPw — VARCHAR(255) — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • phone — VARCHAR(255) — NOT NULL
  • gender — VARCHAR(255) — NOT NULL
  • birthday — VARCHAR(255) — NOT NULL
  • address — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • starPointCode — pk — 외래 키 → 별점.starPointCode — NOT NULL

별점 (Untitled5)

  • starPointCode — pk — 기본 키 — NOT NULL
  • starPointValue — VARCHAR(255)
  • Field2 — VARCHAR(255)
  • contentCode — pk — NOT NULL
  • memberId — pk — NOT NULL
  • commentCode — VARCHAR(255) — NOT NULL
  • starPointDate — VARCHAR(255)
  • contentCode (contentCode2) — pk — 외래 키 → 콘텐츠 테이블.contentCode — NOT NULL
  • commentCode (commentCode2) — VARCHAR(255) — 외래 키 → 코멘트.commentCode — NOT NULL

주최자테이블 (Untitled2)

  • holderCode — pk — 기본 키 — NOT NULL
  • contentCode — pk — 외래 키 → 콘텐츠 테이블.contentCode — NOT NULL
  • holderName — VARCHAR(255)
  • isHolder — VARCHAR(255)
  • enquiry — VARCHAR(255)
  • enquiryTel — VARCHAR(255)

참여자테이블 (Untitled6)

  • creatorCode — pk — 기본 키 — NOT NULL
  • contentCode — pk — 외래 키 → 콘텐츠 테이블.contentCode — NOT NULL
  • creatorName — VARCHAR(255) — NOT NULL
  • creatorTel — VARCHAR(255)

컨첸츠 옵션 테이블 (Untitled1-1)

  • contentOptionCode — pk — 기본 키 — NOT NULL
  • contentCode — pk — 외래 키 → 콘텐츠 테이블.contentCode — NOT NULL
  • toilet — VARCHAR(255)
  • parkinglot — VARCHAR(255)
  • parkinglotSize — VARCHAR(255)
  • forKids — VARCHAR(255)
  • fee — VARCHAR(255)
  • descriptionShort — VARCHAR(255)
  • descriptionLong — VARCHAR(255)

코멘트 (Untitled4)

  • commentCode — VARCHAR(255) — 기본 키 — NOT NULL
  • commentText — VARCHAR(255)
  • commentLike — VARCHAR(255)
  • commentImgCode — VARCHAR(255)
  • starPoint — VARCHAR(255)
  • commnetCreateDate — VARCHAR(255)
  • commnetEditDate — VARCHAR(255)
  • contentCode (contentCode2) — pk — 외래 키 → 콘텐츠 테이블.contentCode — NOT NULL
  • memberId (memberId2) — pk — 외래 키 → 멤버쉽.memberId — NOT NULL

콘텐츠 테이블 (Untitled)

  • contentCode — pk — 기본 키 — NOT NULL
  • contentTitle — VARCHAR(255) — NOT NULL
  • contentType — VARCHAR(255) — NOT NULL
  • startDate — VARCHAR(255) — NOT NULL
  • endDate — VARCHAR(255) — NOT NULL
  • startTime — VARCHAR(255)
  • endTime — VARCHAR(255)
  • area — VARCHAR(255) — NOT NULL
  • place — VARCHAR(255) — NOT NULL