GLEAN

Tables (8)

Counsel

  • counsel_pk — Primary key — NOT NULL
  • counselReservation_pk — Foreign key → CounselReservation.counselReservation_pk — NOT NULL
  • counselor_pk (counselor_pk2) — Foreign key → CounselReservation.counselor_pk — NOT NULL
  • user_pk (user_pk2) — Foreign key → User.user_pk — NOT NULL
  • counsel_startdate
  • counsel_enddate
  • counsel_detail
  • counsel_fee

CounselReservation

  • counselReservation_pk — Primary key — NOT NULL
  • counselor_pk — Foreign key → Counselor.counselor_pk — NOT NULL
  • counsel_startdate
  • counsel_enddate
  • user_pk
  • done
  • matching
  • counsel_fee

Counselor (상담자)

  • counselor_pk — Primary key — NOT NULL
  • counselor_pw
  • counselor_name
  • counselor_age
  • counselor_gender
  • counselor_email
  • counselor_introduce
  • counselor_profile
  • key
  • isuser

CounselorMajor (상담사전공분야)

  • counselor_pk — Foreign key → Counselor.counselor_pk — NOT NULL
  • youth
  • senior
  • pregnant
  • menopause
  • drug
  • cancer
  • thyroid
  • season
  • etc

Meeting (모임)

  • meeting_pk — Primary key — NOT NULL
  • meeting_max
  • meeting_now
  • meeting_startdate
  • meeting_enddate
  • meeting_title
  • meeting_owner
  • meeting_counselor
  • meetingmatching
  • done
  • recruiting

Meetingvisitor (모임참가자)

  • meetingvisitor_pk (Key) — Primary key — NOT NULL
  • meeting_pk — Foreign key → Meeting.meeting_pk — NOT NULL
  • user_pk — Foreign key → User.user_pk — NOT NULL
  • meetingvisitor_reportdate (Field3)
  • done (Field4)

Review (리뷰)

  • review_id — Primary key — NOT NULL
  • user_pk (user_pk2) — Foreign key → User.user_pk — NOT NULL
  • counselor_pk
  • star

User

  • user_pk — Primary key — NOT NULL
  • user_email
  • user_name
  • user_gender
  • user_password
  • user_age
  • issocial
  • isuser