board

Tables (4)

CATEGORY (카테고리)

  • CATEGORY_ID (PK) — INT — Primary key — NOT NULL
  • NAME (Field) — VARCHAR(10)

COMMENT (댓글)

  • COMMENT_ID (PK) — INT — Primary key — NOT NULL
  • POST_ID (PK2) — INT — Foreign key → POST.POST_ID — NOT NULL
  • CONTENT (Field) — VARCHAR(500)
  • REG_DATE (Field2) — TIMESTAMP

FILE (파일)

  • FILE_ID (PK) — INT — Primary key — NOT NULL
  • POST_ID (PK2) — INT — Foreign key → POST.POST_ID — NOT NULL
  • ORIG_NAME (Field) — VARCHAR(100)
  • STORE_NAME (Field2) — VARCHAR(200)
  • EXT (Field3) — VARCHAR(10)
  • STORE_DIR (Field4) — VARCHAR(200)

POST (게시글)

  • POST_ID (PK) — INT — Primary key — NOT NULL
  • CATEGORY_ID (PK2) — INT — Foreign key → CATEGORY.CATEGORY_ID — NOT NULL
  • TITLE (Field) — VARCHAR(100)
  • WRITER (Field2) — CHAR(5)
  • CONTENT (Field4) — VARCHAR(2000)
  • HIT (Field5) — INT
  • REG_DATE (Field6) — TIMESTAMP
  • MOD_DATE (Field7) — TIMESTAMP
  • SALT (Field8) — VARCHAR(32)
  • HASH (Field9) — VARCHAR(64)