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 — 선생 식별