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)
User
- 회원 아이디 (UserId) — varchar(100) — Primary key — NOT NULL
- 회원 이름 (UserName) — varchar(50)
- 회원 비밀번호 (UserPw) — varchar(100)