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