CRUD

Tables (11)

Admin (관리자 정보)

  • Key (admin_id) — bigint — Primary key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Member.mem_id — NOT NULL — pk
  • Field (admin_userid) — varchar2(30) — NOT NULL — 아이디
  • Field2 (admin_password) — varchar2(30) — NOT NULL — 비밀번호
  • Field3 (admin_name) — varchar2(30) — NOT NULL — 실명
  • Field4 (admin_nickname) — varchar2(100) — NOT NULL — 닉네임
  • Field5 (admin_birthday) — varchar2(30) — NOT NULL — 생일
  • Field6 (admin_img) — BLOB — NOT NULL — 프로필 사진
  • Field7 (admin_email) — varchar2(50) — NOT NULL — 이메일
  • Field8 (admin_phone) — varchar2(50) — NOT NULL — 전화번호
  • Field9 (admin_role) — varchar2(50) — NOT NULL — 권한

AutoLogin (자동 로그인)

  • Key (aul_id) — bigint — Primary key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Member.mem_id — NOT NULL — pk
  • Field (aul_key) — varchar2(30) — NOT NULL — 고유 키값, 쿠키로 저장
  • Field (aul_ip) — varchar2(30) — NOT NULL — 회원 IP
  • Field (aul_datetime) — varchar2(100) — NOT NULL — 자동 로그인 시간

Board (게시판)

  • Key (brd_id) — bigint — Primary key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Member.mem_id — NOT NULL — pk
  • Field (brd_name) — varchar2(100) — NOT NULL — 게시판 명
  • Field2 (brd_key) — varchar2(100) — NOT NULL — 게시판 주소
  • Field3 (brd_search) — varchar2(100) — NOT NULL — 게시글 검색

ChatRoom (채팅방)

  • Key (room_id) — bigint — Primary key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Member.mem_id — NOT NULL — pk
  • Field (room_name) — varchar2(30) — NOT NULL — 채팅방 제목
  • Field (room_password) — varchar2(30) — NOT NULL — 비밀번호
  • Field (room_capacity) — integer — NOT NULL — 수용 인원
  • Field (room_enter_user) — integer — NOT NULL — 현재 인원
  • Field (room_create_date) — varchar2(20) — NOT NULL — 생성 시간
  • Field (room_modified_date) — varchar2(20) — NOT NULL — 수정일

ChatUser (채팅방 사용자)

  • Key (chu_id) — bigint — Primary key — NOT NULL — pk
  • Key (room_id) — bigint — Foreign key → ChatRoom.Key — NOT NULL — pk
  • mem_id — bigint — Foreign key → ChatRoom.mem_id — NOT NULL — pk
  • Field (mem_nickname) — varchar2(30) — NOT NULL — 맴버 닉네임
  • Field (mem_name) — varchar2(30) — NOT NULL — 맴버 실명
  • Field (create_date) — varchar2(20) — NOT NULL — 생성 시간
  • Field (modified_date) — varchar2(20) — NOT NULL — 수정일

Comment (댓글)

  • Key (comment_id) — bigint — Primary key — NOT NULL — pk
  • Key (post_id) — bigint — Foreign key → Post.Key — NOT NULL — pk
  • Key (brd_id) — bigint — Foreign key → Post.Key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Post.mem_id — NOT NULL — pk
  • Field (comment) — text — NOT NULL — 댓글
  • Field (created_date) — varchar2(20) — NOT NULL — 생성일
  • Field (modified_date) — varchar2(20) — NOT NULL — 수정일

Follow (팔로우)

  • Key (fol_id) — bigint — Primary key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Member.mem_id — NOT NULL — 팔로우를 신청한 맴버
  • Field (target_mem_id) — varchar2(30) — NOT NULL — 팔로우를 받은 맴버
  • Field (fol_datetime) — datetime — NOT NULL — 팔로우 한 시간

Friends (친구목록)

  • Friend_id — bigint — Primary key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Member.mem_id — NOT NULL — pk
  • mem_nickname — varchar2(30) — NOT NULL — 맴버 닉네임
  • mem_name — varchar2(30) — NOT NULL — 맴버 실명

Invite (채팅 초대)

  • Key (inv_id) — bigint — Primary key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Member.mem_id — NOT NULL — pk
  • Field (mem_nickname) — varchar2(30) — NOT NULL — 맴버 닉네임
  • Field (mem_name) — varchar2(30) — NOT NULL — 맴버 실명
  • Field (create_date) — varchar2(20) — NOT NULL — 생성 시간
  • Field (modified_date) — varchar2(20) — NOT NULL — 수정일

Member (회원정보)

  • mem_id — bigint — Primary key — NOT NULL — pk
  • Field (mem_userid) — varchar2(30) — NOT NULL — 아이디
  • Field2 (mem_password) — varchar2(30) — NOT NULL — 비밀번호
  • Field3 (mem_name) — varchar2(30) — NOT NULL — 실명
  • Field (mem_nickname) — varchar2(100) — NOT NULL — 닉네임
  • Field2 (mem_birthday) — varchar2(30) — NOT NULL — 생일
  • Field4 (mem_address) — varchar2(50) — NOT NULL — 주소
  • Field5 (mem_img) — BLOB — NOT NULL — 프로필 사진
  • Field6 (mem_email) — varchar2(50) — NOT NULL — 이메일
  • Field7 (mem_phone) — varchar2(20) — NOT NULL — 전화번호

Post (게시글)

  • Key (post_id) — bigint — Primary key — NOT NULL — pk
  • Key (brd_id) — bigint — Foreign key → Board.Key — NOT NULL — pk
  • mem_id — bigint — Foreign key → Board.mem_id — NOT NULL — pk
  • Field (post_nickname) — varchar2(100 — NOT NULL — 작성자 닉네임
  • Field (post_title) — varchar2(100) — NOT NULL — 게시글 제목
  • Field (post_content) — CLOB — NOT NULL — 게시글 내용
  • Field (post_view) — bigint — NOT NULL — 조회수
  • Field (post_created_date) — varchar2(20) — NOT NULL — 생성일
  • Field (post_modified_date) — varchar2(20) — NOT NULL — 수정일