버킷리스트

테이블 (7)

고객센터 (Untitled5)

  • customerIdx (Key) — 기본 키 — NOT NULL
  • customerFile (Field5)
  • custoemrSubject (Field)
  • customerText (Field2)
  • customerDate (Field4)
  • customerPassword (Field6)
  • member (Key2) — 외래 키 → 유저.memberIdx — NOT NULL
  • customerSecret (Field3)

공지사항 (Untitled3)

  • aboutNumber (Key) — 기본 키 — NOT NULL
  • about_subject (Field)
  • aboutText (Field2)
  • aboutDate (Field4)
  • aboutFile (Field5)
  • memberIdx (Key2) — 외래 키 → 유저.memberIdx — NOT NULL

유저 (Untitled)

  • memberIdx (Key) — 기본 키 — NOT NULL
  • memberId (Field)
  • user_name (Field2)
  • memberPassword (Field3)
  • memberEamil (Field4)
  • memberPhone (Field5)
  • Role (Field6)
  • zipcode (Field7)
  • streetAdr (Field8)
  • detailAdr (Field9)

참여하기 (Untitled4)

  • participationIdx (Key) — 기본 키 — NOT NULL
  • participationOption (Field)
  • participationTag (Field2)
  • participationText (Field3)
  • participationFile (Field4)
  • participationDate (Field5)
  • participationSubject (Field6)
  • participationCount (Field7)
  • member (Key2) — 외래 키 → 유저.memberIdx — NOT NULL

참여하기 댓글 (Untitled10)

  • commentIdx (Key) — 기본 키 — NOT NULL
  • commentText (Field)
  • participation (Key2) — 외래 키 → 참여하기.participationIdx — NOT NULL
  • member (Key3) — 외래 키 → 유저.memberIdx — NOT NULL

커뮤니티 (Untitled7)

  • communityIdx (Key) — 기본 키 — NOT NULL
  • comminitySubject (Field)
  • communityTag (Field2)
  • communitykind (Field3)
  • communtyText (Field4)
  • communtiyDate (Field5)
  • communityFile (Field6)
  • communityCount (Field7)
  • comments (Field9)
  • memberIdx (Key2) — 외래 키 → 유저.memberIdx — NOT NULL

커뮤니티 댓글 (Untitled9)

  • commentIdx (Key) — 기본 키 — NOT NULL
  • comment_text (Field)
  • member (Key2) — 외래 키 → 유저.memberIdx — NOT NULL
  • community (Key3) — 외래 키 → 커뮤니티.communityIdx — NOT NULL