ㄴㄴㄴㄴ

Tables (8)

BLOG_Board

  • BRDNO — NUMBER — Primary key — NOT NULL
  • BNO — NUMBER — Foreign key → BLOG_INFO.BNO — NOT NULL
  • CNAME — VARCHAR(50)
  • BOARD — SUBJECT"
  • CONTENT — CLOB
  • DATE — DATE
  • HIT — NUMBER

BLOG_CATEGORY

  • CNAME — VARCHAR(50)
  • BNO — NUMBER — Foreign key → BLOG_INFO.BNO — NOT NULL
  • BLOG_INDEX — NUMBER(10)

BLOG_COMMENT

  • CMTNo — NUMBER — Primary key — NOT NULL
  • BRDNo — NUMBER — NOT NULL
  • CMTBasicSet — NUMBER(1)
  • cmtMid — VARCHAR(50)
  • cmtDate — DATE
  • cmtContent — VARCHAR(500)
  • cmtRepl — NUMBER

BLOG_INFO

  • BNO — NUMBER — Primary key — NOT NULL
  • ID — VARCHAR(50) — NOT NULL
  • BLOGTITLE — VARCHAR(50)
  • nName — VARCHAR(50)
  • mPhoto — VARCHAR(100)

BOARD_LIKE

  • LIKENO — NUMBER — Primary key — NOT NULL
  • BRDNO — NUMBER — Foreign key → BLOG_Board.BRDNO — NOT NULL
  • LIKEID — INT — Foreign key → USER.ID — NOT NULL

FILES

  • FILENO — NUMBER — Primary key — NOT NULL
  • BRDNO — NUMBER — Foreign key → BLOG_Board.BRDNO — NOT NULL
  • CName — VARCHAR(50)
  • FILEName — VARCHAR(100)

TAG

  • TNO — NUMBER — Primary key — NOT NULL
  • BRDNO — NUMBER — Foreign key → BLOG_Board.BRDNO — NOT NULL
  • T_CONTENT — VARCHAR(2000)

USER

  • ID — INT — Foreign key — NOT NULL
  • PASSWORD — VARCHAR(30)
  • NAME — VARCHAR(30)
  • NICKNAME — VARCHAR(10)
  • PROFILE_IMAGE — VARCHAR2(100)