ㅁㄴㅇㄹ
테이블 (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