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