now_ERD
Tables (6)
Delete Writing (Untitled)
Emoticon (emoticon)
- Like (like) — varchar(10)
- Hate (hate) — varchar(10)
- Field
Member (member)
- User ID (userid) — varchar(50) — Primary key — NOT NULL
- User Password (upass) — varchar(100) — NOT NULL
- User Name (uname) — vharchar(30) — NOT NULL
- User Mail (umail) — varchar(50)
- User NickName (unick) — varchar(30) — NOT NULL
- User registration (urdate) — datetime — NOT NULL
Writing (writing)
- Subject (subject) — varchar(150) — Primary key — NOT NULL
- Content (content) — varchar(2000)
- Hit (hit) — int — NOT NULL
- Ip (wip) — varchar(15) — NOT NULL
- Writing date (wdate) — datetime — NOT NULL
- Report (report) — int — NOT NULL
Writing Relationship (wrelation)
- Sequence Nomber (seq) — int — Primary key — NOT NULL
- Group (grp) — int — NOT NULL
- Group Sequence Number (grps) — int — NOT NULL
- Group length (grpl) — int — NOT NULL
Writing Topic (wTopic)
- Topicno (tno) — int — Primary key — NOT NULL
- Topic (topic) — varchar(20) — NOT NULL