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