banzzak
Tables (8)
Knitting
- 게시물ID (knit_id) — number — Primary key — NOT NULL
- 닉네임 (nickname) — varchar(10) — Foreign key → User.닉네임 — NOT NULL
- 제목 (knit_title) — text
- 내용 (knit_content) — text
- 작성일 (knit_date) — date
Knitting_Comment (Knitting_comment)
- 게시물ID (knit_id) — number — Foreign key → Knitting.게시물ID — NOT NULL
- 닉네임 (nickname) — varchar(10) — Foreign key → Knitting.닉네임 — NOT NULL
- 댓글 (knit_comment) — text
- knit_com_date (Field) — date
Untitled (Crochet)
- 게시물ID (cro_id) — varchar(20) — Primary key — NOT NULL
- 닉네임 (nickname) — varchar(10) — Foreign key → User.닉네임 — NOT NULL
- 제목 (cro_title) — text
- 내용 (cro_content) — text
- 작성일 (cro_date) — date
Untitled (Crochet_Comment)
- 게시물ID (cro_id) — varchar(20) — Foreign key → Untitled.게시물ID — NOT NULL
- 닉네임 (nickname) — varchar(10) — Foreign key → Untitled.닉네임 — NOT NULL
- 댓글 (cro_comment) — text
- 작성일 (cro_com_date) — date
Untitled (Crochet_LikeIt)
- 게시물ID (cro_id) — varchar(20) — Foreign key → Untitled.게시물ID — NOT NULL
- 닉네임 (nickname) — varchar(10) — Foreign key → Untitled.닉네임 — NOT NULL
Untitled (Notice)
- 관리자ID (manage_id) — varchar(20)
- 제목 (notice_title) — text
- 내용 (notice_content) — text
- 작성일 (notice_date) — date
Untitled4 (Knitting_LikeIt)
- 게시물ID (knit_id) — number — Foreign key → Knitting.게시물ID — NOT NULL
- 닉네임 (nickname) — varchar(10) — Foreign key → Knitting.닉네임 — NOT NULL
User
- 닉네임 (nickname) — varchar(10) — Primary key — NOT NULL
- 아이디 (user_id) — varchar(20)
- 비밀번호 (password) — varchar(20)
- 이름 (user_name) — varchar(10)
- 이메일 (user_email)