breadProj
Tables (5)
BAKERIES (Untitled4)
- ID (게시글 ID) — number — Primary key — NOT NULL
- TITLE (게시글 제목) — string
- CREATE_AT (작성날짜) — datetime
- UPDATE_AT (수정날짜) — datetime
- VIEW (조회수) — number
- COMMENTS (댓글) — array<comment>
- LIKES (좋아요) — number
- BODY (본문) — string
- PICTURE (사진) — array<string>
- ID (유저ID) — number — Foreign key → USERS.ID — NOT NULL
BAKERIES_COMMENT (CopyOfUntitled5)
- ID (댓글 ID) — number — Primary key — NOT NULL
- BODY (댓글내용) — string
- CREATE_AT (작성일자) — datetime
- ID (게시글 ID) — number — Foreign key → BAKERIES.ID — NOT NULL
- ID (유저ID) — number — Foreign key → USERS.ID — NOT NULL
RECIPES (Untitled)
- ID (게시글 ID) — number — Primary key — NOT NULL
- TITLE (게시글 이름) — string
- CREATE_AT (작성날짜) — datetime
- UPDATE_AT (수정날짜) — datetime
- SHARE (공유여부) — boolean
- VIEW (조회수) — number
- COMMENTS (댓글) — array<comment>
- LIKES (좋아요) — number
- BODY (본문) — string
- PICTURES (사진) — array<string>
- STAR (별점) — number
- INGREDIENTS (재료) — array<object>
- NUTRITION (영양정보) — array<object>
- ID (유저ID) — number — Foreign key → USERS.ID — NOT NULL
RECIPES_COMMENT (Untitled5)
- ID (댓글 ID) — number — Primary key — NOT NULL
- BODY (댓글내용) — string
- CREATE_AT (작성일자) — datetime
- ID (게시글 ID) — number — Foreign key → RECIPES.ID — NOT NULL
- ID (유저ID) — number — Foreign key → USERS.ID — NOT NULL
USERS (Untitled2)
- ID (유저ID) — number — Primary key — NOT NULL
- EMAIL (이메일) — string
- PASSWD (비밀번호) — string
- NICKNAME (닉네임) — string
- LAST_VISIT (마지막 로그인) — datetime
- PICTURE (프로필사진) — string
- GRANT (유저권한) — number