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)