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 — 수정일