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