Dear Me

Tables (19)

board (Untitled14)

  • Key — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • title (Field) — String — NOT NULL
  • contents (Field2) — String — NOT NULL
  • date (Field3) — Date — NOT NULL

career (Untitled2)

  • Key — Long — Primary key — NOT NULL
  • contents (Field) — String — NOT NULL
  • counselor_id (Key2) — Long — Foreign key → counselor_profile.counselor_id — NOT NULL

category (Untitled19)

  • Key (Key2) — Long — Primary key — NOT NULL
  • counselor_id (Key) — Long — Foreign key → counselor_profile.counselor_id — NOT NULL
  • contents (Field) — String — NOT NULL

certificate (Untitled3)

  • Key — Long — Primary key — NOT NULL
  • contents (Field) — String — NOT NULL
  • counselor_id (Key2) — Long — Foreign key → counselor_profile.counselor_id — NOT NULL

comment (Untitled15)

  • Key — Long — Primary key — NOT NULL
  • board_id (Key2) — Long — Foreign key → board.Key — NOT NULL
  • counselor_id (Key3) — Long — Foreign key → user.Key — NOT NULL
  • date (Field) — Date — NOT NULL
  • contents (Field2) — String — NOT NULL

counseling (Untitled10)

  • Key — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • counselor_id (Key3) — Long — Foreign key → user.Key — NOT NULL
  • group_id (Key4) — Long — Foreign key → group.Key
  • date (Field) — Date — NOT NULL
  • type (Field2) — String — NOT NULL — accepted, isaccepted인지

counselor_profile (Untitled18)

  • counselor_id (Key) — Long — Foreign key → user.Key — NOT NULL
  • price (Field2) — Number — NOT NULL
  • introduce (Field3) — String — NOT NULL
  • value (Field) — Number — NOT NULL — review점수

couseling_document (Untitled13)

  • Key — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • counselor_id (Key3) — Long — Foreign key → user.Key — NOT NULL
  • contents (Field) — String — NOT NULL
  • date (Field2) — Date
  • is_accepted (Field3) — String — NOT NULL — 정보공개 허용 여부
  • group_id (Key4) — Long — Foreign key → group.Key

document (Untitled12)

  • Key — Long — Primary key — NOT NULL
  • counselor_id (Key2) — Long — Foreign key → counselor_profile.counselor_id — NOT NULL
  • file_name (Field) — String — NOT NULL
  • real_file_name (Field2) — String — NOT NULL

emoji (Untitled9)

  • Key (Key3) — Long — Primary key — NOT NULL
  • text_diary_id (Key) — Long — Foreign key → text_diary.Key
  • video_diary_id (Key2) — Long — Foreign key → video_diary.Key
  • type (Field) — String — 세가지 존재

favorite (Untitled6)

  • Key — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • counselor_id (Key3) — Long — Foreign key → user.Key — NOT NULL

group (Untitled8)

  • Key — Long — Primary key — NOT NULL
  • counselor_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • title (Field) — String — NOT NULL
  • contents (Field2) — String — NOT NULL
  • price (Field3) — Number — NOT NULL

group_member (Untitled11)

  • Key (Key3) — Long — Primary key — NOT NULL
  • user_id (Key) — Long — Foreign key → user.Key — NOT NULL
  • group_id (Key2) — Long — Foreign key → group.Key — NOT NULL

info_open (Untitled17)

  • Key — Long — Foreign key → couseling_document.Key — NOT NULL
  • is_open (Field) — String — NOT NULL — open, closed

meeting_room (Untitled16)

  • Key — Long — Primary key — NOT NULL
  • counselor_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • group_id (Key3) — Long — Foreign key → group.Key

review (Untitled7)

  • Key — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • counselor_id (Key3) — Long — Foreign key → user.Key — NOT NULL
  • value (Field) — Number — NOT NULL
  • contents (Field2) — String — NOT NULL

text_diary (Untitled5)

  • Key — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • contents (Field) — String — NOT NULL
  • created_time (Field2) — Date — NOT NULL

user (Untitled)

  • Key — Long — Primary key — NOT NULL
  • id (Field) — String — NOT NULL
  • pw (Field2) — String — NOT NULL
  • gender (Field3) — String — NOT NULL
  • birth (Field4) — Date — NOT NULL
  • email (Field5) — String — NOT NULL
  • type (Field8) — String — NOT NULL — 일반사용자인지 상담사인지
  • nick_name (Field6) — String — 일반사용자일경우만 필수
  • picture (Field7) — String — 상담사일 경우만 필수
  • points (Field9) — Number — NOT NULL

video_diary (Untitled4)

  • Key — Long — Primary key — NOT NULL
  • user_id (Key2) — Long — Foreign key → user.Key — NOT NULL
  • real_file_name (Field) — String — NOT NULL
  • file_name (Field2) — String — NOT NULL
  • created_time (Field3) — Date — NOT NULL
  • contents (Field4) — String — NOT NULL