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