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가지 유형