펫크인

테이블 (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