db
Tables (6)
Category
- CategoryID — INT — NOT NULL
- CategoryKorName — VARCHAR(255)
Comments
- CommentsNo — INT — NOT NULL
- UserID — INT
- CommentsDate — DATE
- Comment — VARCHAR(200) — NOT NULL — ARCHAR(200) NOT NUL
- BulletinNo — INT
- parent_comment_id — INT
SmallCategory
- SmallCategoryID — INT — Primary key — NOT NULL
- CategoryID — INT — Primary key — NOT NULL
- SmallCategoryKorName — VARCHAR(255)
- SmallCategoryName — VARCHAR(255)
UserInfo
- userNo — int — Primary key — NOT NULL
- ID — varchar(20) — NOT NULL
- Password — varchar(20) — NOT NULL
- Email — varchar(30) — NOT NULL
- Name — varchar(15) — NOT NULL
- PhoneNumber — varchar(15) — NOT NULL
Writing
- WritiingID — INT — Primary key — NOT NULL
- WritingTitle — VARCHAR(200)
- WritingTagID — INT
- MiniCategoryID — INT
- UserID — VARCHAR(20)
- CreateDate — DATE
- Text — VARCHAR(1000)
WritingTag
- WritiingID — INT — Foreign key → Writing.WritiingID — NOT NULL
- WritingTagID — INT — NOT NULL
- WritingTagName — VARCHAR(200)
- MiniCategoryID — INT
- userNo — int — Foreign key → UserInfo.userNo — NOT NULL