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