펫크인
테이블 (8)
COMMENT (댓글)
- Key — 기본 키 — NOT NULL
- MEMBER_ID (회원ID) — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL — 회원아이디
DEVICE (로그인장치)
- DEVICE_ID (디바이스ID) — BIGINT — 기본 키 — NOT NULL
- MEMBER_ID (회원ID) — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL — 회원아이디
- DEVICE_MODEL (장치모델) — VARCHAR — NOT NULL
- DEVICE_OS_TYPE (장치OS종류) — VARCHAR — NOT NULL
- DEVICE_OS_VERSION (장치OS버전) — VARCHAR — NOT NULL
IMAGE (사진)
- IMAGE_ID (사진ID) — BIGINT — 기본 키 — NOT NULL — 사진
- RELATED_IMAGE_ID (연결ID) — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL
MEMBER (회원)
- MEMBER_ID (회원ID) — BIGINT — 기본 키 — NOT NULL — 회원아이디
- MEMBER_NICKNAME (회원별명) — VARCHAR — NOT NULL
- MEMBER_PASSWORD (회원비밀번호) — VARCHAR — NOT NULL
- MEMBER_PHONENUMBER (회원전화번호) — BIGINT — NOT NULL
- MEMBER_SEX (회원성별) — VARCHAR — NOT NULL
- MEMBER_ADDRESS (회원주소) — VARCHAR — NOT NULL
- MEMBER_EMAIL (회원이메일) — VARCHAR — NOT NULL
- MEMBER_INST_DATE (회원가입일) — DATE — NOT NULL
- MEMBER_UPDT_DATE (정보수정일) — DATE — NOT NULL
POST (게시글)
- Key — 기본 키 — NOT NULL
- MEMBER_ID (회원ID) — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL — 회원아이디
SERVICE_LOG (서비스로그)
- MEMBER_ID (회원ID) — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL — 회원아이디
- PASSWORD_CHANGE_DATGE (비밀번호변경일) — DATETIME
- CONNECT_DATE (마지막접속일) — DATETIME
- CONNECT_CNT (접속횟수) — BIGINT
TERMS (약관)
- TERMS_CODE (약관코드) — VARCHJAR — 외래 키 → TERMS_AGREE.TERMS_CODE — NOT NULL
- TERMS_NAME (약관명) — VARCHAR — NOT NULL
- TERMS_CONDITION (약관내용) — VARCHAR — NOT NULL
- REQUIRED_STATUS (필수여부) — VARCHAR — NOT NULL
TERMS_AGREE (약관동의)
- TERMS_CODE (약관코드) — VARCHJAR — 기본 키 — NOT NULL
- MEMBER_ID (회원ID) — BIGINT — 외래 키 → MEMBER.MEMBER_ID — NOT NULL — 회원아이디
- AGREEMENT (동의여부) — VARCHAR — NOT NULL
- AGREEMENT_DATE (동의일자) — DATETIME — NOT NULL