ASAD
Tables (13)
Attachment
- AttachmentID — INT — Primary key — NOT NULL
- PostID — INT — NOT NULL
- OriginalFileName — VARCHAR(255)
- SavedFileName — VARCHAR(255)
- FilePath — VARCHAR(255)
- FileSize — BIGINT
- Extension — VARCHAR(10)
Authority
- AuthorityCode — VARCHAR(50) — Primary key — NOT NULL
- AuthorityName — VARCHAR(100) — NOT NULL
- AuthorityDesc — TEXT
Board
- BoardCode — VARCHAR(50) — Primary key — NOT NULL
- BoardName — VARCHAR(100) — NOT NULL
Comment
- CommentID — INT — Primary key — NOT NULL
- PostID — INT — NOT NULL
- WriterID — VARCHAR(50) — NOT NULL
- CommentContent — TEXT
- CreatedAt — DATETIME — NOT NULL
Log
- LogID — BIGINT — Primary key — NOT NULL
- UserID — VARCHAR(50)
- AccessedAt — DATETIME
- AccessIP — VARCHAR(50)
- AccessPath — VARCHAR(255)
- Action — TEXT
Menu
- MenuCode — VARCHAR(50) — Primary key — NOT NULL
- MenuGroupCode — VARCHAR(50) — NOT NULL
- MenuName — VARCHAR(100) — NOT NULL
- MenuURL — VARCHAR(255)
- SortOrder — INT
- IsVisible — BOOLEAN
MenuGroup
- MenuGroupCode — VARCHAR(50) — Primary key — NOT NULL
- MenuGroupName — VARCHAR(100) — NOT NULL
Notice
- NoticeID — INT — Primary key — NOT NULL
- Title — VARCHAR(255) — NOT NULL
- Content — TEXT
- WriterID — VARCHAR(50) — NOT NULL
- CreatedAt — DATETIME — NOT NULL
- StartAt — DATETIME
- EndAt — DATETIME
- IsPopup — BOOLEAN
- ViewCount — INT
Post
- PostID — INT — Primary key — NOT NULL
- BoardCode — VARCHAR(50) — NOT NULL
- WriterID — VARCHAR(50) — NOT NULL
- PostTitle — VARCHAR(200) — NOT NULL
- PostContent — TEXT
- CreatedAt — DATETIME — NOT NULL
- ViewCount — INT
- CommentCount — INT
- Attachment — VARCHAR(255)
- IsNotice — BOOLEAN
- IsDeleted — BOOLEAN
Program
- ProgramCode — VARCHAR(50) — Primary key — NOT NULL
- ProgramName — VARCHAR(255) — NOT NULL
- ProgramPath — VARCHAR(255)
- MenuCode — VARCHAR(50)
User
- UserID — VARCHAR(50) — Primary key — NOT NULL
- Password — VARCHAR(255) — NOT NULL
- Name — VARCHAR(100) — NOT NULL
- Email — VARCHAR(255)
- PhoneNumber — VARCHAR(20)
- RegisteredAt — DATETIME
- LastLogin — DATETIME
- Status — VARCHAR(20)
UserAuthority
- UserID — VARCHAR(50) — Primary key — NOT NULL
- AuthorityCode — VARCHAR(50) — Primary key — NOT NULL
UserProgramAuthority
- UserID — VARCHAR(50) — Primary key — NOT NULL
- ProgramCode — VARCHAR(50) — Primary key — NOT NULL
- CanRead — BOOLEAN
- CanCreate — BOOLEAN
- CanUpdate — BOOLEAN
- CanDelete — BOOLEAN