notice

Tables (5)

Comment (댓글)

  • comment_id (PK) — 숫자 — Primary key — NOT NULL
  • msg (댓글내용) — 문자열
  • user (댓글작성자) — 문자열
  • writedate (댓글등록일) — 날짜
  • read_count (조회수) — 숫자
  • news_id (PK2) — 숫자 — Foreign key → News.news_id — NOT NULL

News (뉴스게시판)

  • news_id (PK) — 숫자 — Primary key — NOT NULL
  • title (제목) — 문자열
  • writer (작성자) — 문자열
  • content (내용) — 문자열
  • regdate (등록일) — 문자열
  • hit (조회수) — 숫자

SUBCATEGORY (Untitled2)

  • SUBCATEGORY_ID (PK) — 숫자 — Primary key — NOT NULL
  • SUBNAME (하위이름) — 문자열
  • TOPCATEGORY_ID (PK2) — 숫자 — Foreign key → TOPCATEGORY.TOPCATEGORY_ID — NOT NULL

TOPCATEGORY (Untitled)

  • TOPCATEGORY_ID (PK) — 숫자 — Primary key — NOT NULL
  • TOPNAME (상위이름) — 문자

notice (공지게시판)

  • notice_id (pk) — 숫자 — Primary key — NOT NULL
  • title (제목) — 문자
  • Field