marklog
Tables (7)
Notice (NOTICE)
- id (ID) — INT — Primary key — NOT NULL
- user (USER_ID) — INT — Foreign key → User.id — NOT NULL
- content (CONTENT) — TEXT — NOT NULL
- noticeType (NOTICE_TYPE) — VARCHAR(255) — NOT NULL
- url (URL) — VARCHAR(255)
Post (POST)
- id (ID) — INT — Primary key — NOT NULL
- user (USER_ID) — INT — Foreign key → User.id — NOT NULL
- summary (SUMMARY) — VARCHAR(30)
- thumbnail (THUMBNAIL) — VARCHAR(50)
- title (TITLE) — VARCHAR(50) — NOT NULL
- content (CONTENT) — TEXT — NOT NULL
- RegisterDatetime (REGISTER_DATETIME) — DATETIME — NOT NULL
- UpdateDatetime (UPDATE_DATETIME) — DATETIME — NOT NULL
PostComment (POST_COMMENT)
- ID — INT — Primary key — NOT NULL
- post (POST_ID) — INT — Foreign key → Post.id — NOT NULL
- Comment (CONTENT) — TEXT — NOT NULL
- RegisterDatetime (REGISTER_DATETIME) — DATETIME — NOT NULL
- UpdateDatetime (UPDATE_DATETIME) — DATETIME — NOT NULL
PostTag (POST_TAG)
- id (ID) — INT — Foreign key → Post.id — NOT NULL
- id (ID2) — INT — Foreign key → Tag.id — NOT NULL
Tag (TAG)
- id (ID) — INT — Primary key — NOT NULL
- name (NAME) — VARCFHAR — NOT NULL
User (USER)
- id (ID) — int — Primary key — NOT NULL
- email (EMAIL) — varchar(30) — NOT NULL
- name (NAME) — VARCHAR(20) — NOT NULL
- picture (PICTURE) — VARCHAR(50) — NOT NULL
- Introduce (INTRODUCE) — VARCHAR(50)
- title (TITLE) — VARCHAR(50) — NOT NULL
- registerDatetime (REGISTER_DATETIME) — DATETIME — NOT NULL
- updateDatetime (UPDATE_DATETIME) — DATETIME — NOT NULL
postLike (POST_LIKE)
- post (POST_ID) — INT — Foreign key → Post.id — NOT NULL
- user (USER_ID) — INT — Foreign key → User.id — NOT NULL