studyproject
Tables (6)
board_comment (CopyOfCopyOfCopyOfUntitled4)
- c_id — serial — Primary key — NOT NULL — 게시판 댓글 식별
- role — enum — 역할
- comment — text — 게시판 댓글
- created_at — timestamp — NOT NULL
- created_by — varchar(50)
- modified_at — timestamp — NOT NULL
- modified_by — varchar(50)
- deleted_at — timestamp
- deleted_by — varchar(50)
- is_deleted — boolean
- id (id2) — serial — Foreign key → user.id — NOT NULL — 유저 식별
- b_id — serial — Foreign key → user_board.b_id — NOT NULL — 게시판 글 식별
studentboard (CopyOfUntitled4)
- s_id — serial — Primary key — NOT NULL — 학생 식별
- grade — varchar(50) — NOT NULL — 학년
- necessity — varchar(50) — NOT NULL — 과외 필요정도
- s_subject — varchar(50) — NOT NULL — 원하는 과목
- s_style — varchar(255) — 원하는 과외 스타일
- s_location — varchar(255) — NOT NULL — 과외가능 지역
- s_pay — varchar(255) — 과외 비용
- s_date — varchar(50) — 과외 가능 요일
- s_time — varchar(100) — 과외 가능 시간
- etc — varchar(255) — 기타사항
- created_at — timestamp — NOT NULL
- created_by — varchar(50)
- modified_at — timestamp — NOT NULL
- modified_by — varchar(50)
- deleted_at — timestamp
- deleted_by — varchar(50)
- is_deleted — boolean
- id (id2) — serial — Foreign key → user.id — NOT NULL — 유저 식별
- kakao (Field) — varchar(100)
teacherboard (Untitled4)
- t_id — serial — Primary key — NOT NULL — 선생 식별
- id (id2) — serial — Foreign key → user.id — NOT NULL — 유저 식별
- job — varchar(50) — NOT NULL — 직업
- introduction — varchar(255) — 한줄 소개
- subject — varchar(50) — NOT NULL — 과목
- style — varchar(255) — 과외 스타일
- t_location — varchar(255) — NOT NULL — 과외가능 지역
- t_pay — varchar(255) — 과외 비용
- t_date — varchar(50) — 과외 가능 요일
- t_time — varchar(100) — 과외 가능 시간
- t_school — varchar(50) — NOT NULL — 최종 학력
- etc — varchar(255) — 기타사항
- created_at — timestamp — NOT NULL
- created_by — varchar(50)
- modified_at — timestamp — NOT NULL
- modified_by — varchar(50)
- deleted_at — timestamp
- deleted_by — varchar(50)
- is_deleted — boolean
- kakao (Field) — varchar(100)
- profilUrl (Field2) — varchar(255) — 프로필사진Url
user (Untitled)
- id — serial — Primary key — NOT NULL — 유저 식별
- email — varchar(255) — NOT NULL — 이메일(아이디)
- password — varchar(255) — NOT NULL — 비밀번호
- real_name — varchar(255) — 성명
- created_at — timestamp — NOT NULL — 언제 만듬
- created_by — varchar(50) — 누가 만듬
- modified_at — timestamp — NOT NULL — 언제 수정
- modified_by — varchar(50) — 누가 수정
- deleted_at — timestamp — 언제 삭제 했는가
- deleted_by — varchar(50) — 누가 삭제했는가
- deleted_reason — varchar(255) — 삭제 이유
- is_deleted — boolean — 소프트 삭제
- role — boolean — 학생, 선생 구분
user_board (CopyOfCopyOfCopyOfUntitled42)
- b_id — serial — Primary key — NOT NULL — 게시판 글 식별
- role — enum — 역할
- title — varchar(255) — 제목
- detail — text — 내용
- created_at — timestamp — NOT NULL
- created_by — varchar(50)
- modified_at — timestamp — NOT NULL
- modified_by — varchar(50)
- deleted_at — timestamp
- deleted_by — varchar(50)
- is_deleted — boolean
- id (id2) — serial — Foreign key → user.id — NOT NULL — 유저 식별
user_reviews (CopyOfCopyOfUntitled4)
- r_id — serial — Primary key — NOT NULL — 리뷰 식별
- role — enum — 역할
- review — text — 리뷰 댓글
- rating — int — 별점
- created_at — timestamp — NOT NULL
- created_by — varchar(50)
- modified_at — timestamp — NOT NULL
- modified_by — varchar(50)
- deleted_at — timestamp
- deleted_by — varchar(50)
- is_deleted — boolean
- id (id2) — serial — Foreign key → user.id — NOT NULL — 유저 식별
- t_id — serial — Foreign key → teacherboard.t_id — NOT NULL — 선생 식별