test

Tables (4)

Board

  • Board_id — VARCHAR(50)
  • //게시물 — 아이디 — NOT NULL
  • //작성자 — 아이디 — NOT NULL
  • //카테고리 — 아이디
  • 카테고리 — 테이블과 — NOT NULL
  • content — TEXT — NOT NULL
  • creation_date — TIMESTAMP
  • modification_date — TIMESTAMP
  • likes — INT
  • comments — INT

Category

  • category_id — INT
  • category_name — VARCHAR(100) — NOT NULL
  • category_description — TEXT

Comment

  • comment_id — VARCHAR(50)
  • Board_id — VARCHAR(50) — NOT NULL
  • //게사물 — 아이디 — NOT NULL
  • content — TEXT — NOT NULL
  • creation_date — TIMESTAMP
  • modification_date — TIMESTAMP

Member

  • mem_id — VARCHAR(50)
  • username — VARCHAR(50) — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • registration_date — TIMESTAMP
  • profile_picture — VARCHAR(255)
  • Tel — VARCHAR(20) — NOT NULL