SpaceGroup

Tables (6)

Untitled (spaceInfo)

  • Key (공간고유번호) — Integer — Primary key — NOT NULL — autoincrease
  • Key (공간등록회원번호) — Integer — Foreign key → user.Key — NOT NULL — autoincrease
  • Field (공간명) — String
  • Field (공간유형) — String
  • Field (공간주소) — String
  • Field (시간당금액) — Number
  • Field (공간정보(소개)) — Text
  • Field (공간 시설안내) — Text
  • Field (공간 유의사항) — Text
  • Field (공간 등록날짜) — Date

Untitled (rentalInfo)

  • Key (대여고유번호) — Integer — Primary key — NOT NULL
  • Key (회원번호) — Integer — Foreign key → user.Key — NOT NULL — autoincrease
  • Key (공간고유번호) — Integer — Foreign key → Untitled.Key — NOT NULL — autoincrease
  • Field (대여시작시각) — Integer
  • Field (대여종료시각) — Integer
  • Field (대여날짜) — Date
  • Field (대여금액) — Int

Untitled (board)

  • Key (게시글 고유번호) — Integer — Primary key — NOT NULL
  • Key (회원번호) — Integer — Foreign key → user.Key — NOT NULL — autoincrease
  • Field (게시글 제목) — String
  • Field (게시글 내용) — Text
  • Field (게시글 작성날짜) — Date

Untitled (reply)

  • Key (댓글 고유번호) — Integer — Primary key — NOT NULL
  • Key (게시글 고유번호) — Integer — Foreign key → Untitled.Key — NOT NULL
  • Key (회원번호) — Integer — Foreign key → user.Key — NOT NULL — autoincrease
  • Field (댓글내용) — Text
  • Field (상위 댓글 고유번호) — Integer
  • Field (댓글 작성날짜) — Date

Untitled (spaceImage)

  • Key (공간 이미지 고유번호) — Integer — Primary key — NOT NULL
  • Key (공간고유번호) — Integer — Foreign key → Untitled.Key — NOT NULL — autoincrease
  • Field (이미지 경로) — String

user

  • Key (회원번호) — Integer — Primary key — NOT NULL — autoincrease
  • Field (회원아이디) — String — NOT NULL — 중복금지
  • Field (회원비밀번호) — String — NOT NULL
  • Field (회원닉네임) — String
  • Field (회원유형) — String — guest, host, admin 3가지 유형