SSF Community

Tables (4)

Board (board)

  • Board Number (no) — INT — Primary key — NOT NULL
  • Board Title (title) — VARCHAR2(200)
  • Board Content (content) — VARCHAR2(4000)
  • Board Date (date) — Date
  • Board Category (category) — TINYINT
  • Board Views (views) — INT
  • Member Id (id) — VARCHAR2(100) — Foreign key → Member.Member Id — NOT NULL

Comment (comment)

  • Comment Number (number) — INT — Primary key — NOT NULL
  • Comment Content (content) — VARCHAR2(4000)
  • Comment Date (date) — Date
  • Member Id (id) — VARCHAR2(100) — Foreign key → Member.Member Id — NOT NULL
  • Board Number (no) — INT — Foreign key → Board.Board Number — NOT NULL

File (file)

  • File Number (f_no) — INT — Primary key — NOT NULL
  • File OriginalName (orgname) — VARCHAR2(100)
  • File StoredName (storedname) — VARCHAR2(100)
  • File Size (size) — INT
  • File Extension (Extension) — VARCHAR2(20)
  • File Path (Path) — VARCHAR2(250)
  • File Delete_YN (Delete_YN) — VARCHAR(1)
  • File Date (Date) — Date
  • Board Number (no) — INT — Foreign key → Board.Board Number — NOT NULL

Member (member)

  • Member Id (id) — VARCHAR2(100) — Primary key — NOT NULL
  • Member Pw (pw) — VARCHAR2(100)
  • Member Email (email) — VARCHAR2(100)
  • Member Phone (phone) — NUMBER
  • Member Grade (grade) — VARCHAR(1)
  • Member Date (date) — Date
  • Member Address (address) — VARCHAR2(300)
  • Member Name (name) — VARCHAR2(100)
  • Member Role (role) — VARCHAR(1)
  • Member Enabled (enabled) — VARCHAR(1)