SNUAAA

Tables (13)

tb_album

  • 게시글id (object_id) — character varying(16) — Foreign key → tb_content.게시글id — NOT NULL

tb_board

  • board_id — character varying(16) — Primary key — NOT NULL
  • board_name — character varying(16) — NOT NULL
  • board_type — character varying(16)
  • lv_read — integer
  • lv_write — integer
  • lv_edit — integer

tb_category

  • category_id — character varying(16) — Primary key — NOT NULL
  • board_id — character varying(16) — Foreign key → tb_board.board_id — NOT NULL
  • category_name — character varying(40)

tb_comment

  • 댓글id (comment_id) — character varying(16) — Primary key — NOT NULL
  • 게시글id (parent_id) — character varying(16) — Foreign key → tb_content.게시글id — NOT NULL
  • 작성자id (author_id) — character varying(16) — Foreign key → tb_user.유저id — NOT NULL
  • 댓글uuid (comment_uuid) — character varying(32)
  • 본문 (contents) — text
  • 추천수 (like_num) — integer
  • 생성시각 (created_at) — timestamp with time zone
  • 수정시각 (updated_at) — timestamp with time zone

tb_comment_like

  • 댓글id (comment_id) — character varying(16) — Foreign key → tb_comment.댓글id — NOT NULL
  • 유저id (user_id) — character varying(16) — Foreign key → tb_user.유저id — NOT NULL

tb_content (tb_object)

  • 게시글id (content_id) — character varying(16) — Primary key — NOT NULL
  • 작성자id (author_id) — character varying(16) — Foreign key → tb_user.유저id — NOT NULL
  • 카테고리id (category_id) — character varying(16) — Foreign key → tb_category.category_id
  • 게시판id (board_id) — character varying(16) — Foreign key → tb_board.board_id
  • 게시글uuid (object_uuid) — character varying(32)
  • 게시글타입 (type) — character varying(16) — 'PT' : POST 'AL' : ALBUM 'PH' : PHOTO 'DC' : DOCUMENT
  • 제목 (title) — character varying(64)
  • 본문 (contents) — text
  • 조회수 (view_num) — integer
  • 댓글수 (comment_num) — integer
  • 추천수 (like_num) — integer
  • 생성시각 (created_at) — timestamp with time zone — NOT NULL
  • 수정시각 (updated_at) — timestamp with time zone

tb_document

  • 게시글id (object_id) — character varying(16) — Foreign key → tb_content.게시글id — NOT NULL
  • 회기 (generation) — integer
  • 파일경로 (file_path) — character varying[](200)

tb_object_like

  • 게시글id (object_id) — character varying(16) — Foreign key → tb_content.게시글id — NOT NULL
  • 유저id (user_id) — character varying(16) — Foreign key → tb_user.유저id — NOT NULL

tb_object_tag (tb_photo_tag)

  • tag_id — character varying(16) — Foreign key → tb_tag.tag_id — NOT NULL
  • 게시글id (object_id) — character varying(16) — Foreign key → tb_content.게시글id — NOT NULL

tb_photo

  • 게시글id (object_id) — character varying(16) — Foreign key → tb_content.게시글id — NOT NULL
  • 앨범id (album_id) — character varying(16) — Foreign key → tb_album.게시글id
  • 사진경로 (file_path) — character varying(200)
  • 썸네일경로 (thumbnail_path) — character varying(200)
  • 촬영일시 (date) — character varying(32)
  • 촬영장소 (location) — character varying(64)
  • 카메라 (camera) — character varying(64)
  • 렌즈 (lens) — character varying(64)
  • 초점거리 (focal_length) — character varying(8)
  • F수 (f_stop) — character varying(8)
  • 노출시간 (expsure_time) — character varying(8)
  • ISO (iso) — character varying(8)

tb_post

  • 게시글id (object_id) — character varying(16) — Foreign key → tb_content.게시글id — NOT NULL

tb_tag

  • tag_id — character varying(16) — Primary key — NOT NULL
  • tag_name — character varying(40)
  • board_id — character varying(16) — Foreign key → tb_board.board_id — NOT NULL

tb_user

  • 유저id (user_id) — character varying(16) — Primary key — NOT NULL
  • 유저uuid (user_uuid) — character varying(32)
  • 아이디 (id) — character varying(16) — NOT NULL
  • 패스워드 (password) — character varying(64) — NOT NULL
  • 이름 (name) — character varying(16) — NOT NULL
  • 가입번호 (aaa_no) — character varying(16)
  • 닉네임 (nickname) — character varying(16) — NOT NULL
  • 학번 (col_no) — character varying(16)
  • 전공 (major) — character varying(32)
  • 이메일 (email) — character varying(64) — NOT NULL
  • 휴대폰번호 (mobile) — character varying(16) — NOT NULL
  • 자기소개 (introduction) — text
  • 프로필사진경로 (profile_path) — character varying(200)
  • 레벨 (level) — integer
  • 가입일자 (created_at) — timestamp with time zone — NOT NULL
  • 접속일자 (login_at) — timestamp with time zone
  • 업데이트일자 (updated_at) — timestamp with time zone