vegup

Tables (5)

Comments (Comment)

  • 댓글번호 (Comment_id) — int — Primary key — NOT NULL
  • 게시물번호 (post_id) — int
  • 댓글내용 (content) — text
  • 댓글작성시간 (Comment_at) — current_timestamp
  • Field (author) — varchar(50)
  • Field

Cookmmunity

  • 게시물번호 (Post_id) — int — Primary key — NOT NULL
  • 제목 (Title) — varchar(1000)
  • 내용 (content) — text
  • 작성날짜 (PostDate) — current_timestamp
  • 회원 이름 (author) — varchar(50)

Recipe

  • Field (Recipe_id) — int — Primary key
  • Field (title) — varchar(50)
  • Field (decription) — text
  • Field (ingredients) — text
  • Field (image_url) — varchar(255)
  • Field (video_url) — varchar(255)

Untitled

    User

    • 회원 아이디 (UserId) — varchar(100) — Primary key — NOT NULL
    • 회원 이름 (UserName) — varchar(50)
    • 회원 비밀번호 (UserPw) — varchar(100)