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)