Shard It
Tables (5)
COMMENT (tb_comment)
- ID (Key) — int — Primary key — NOT NULL
- POSTER_ID (Key2) — int — Foreign key → POSTER.ID — NOT NULL
- USER_ID (Key3) — int — Foreign key → POSTER.USER_ID — NOT NULL
- CONTENT (Field) — varcher(100)
- CREATE_AT (Field2) — datetime
- MODIFYED_AT (Field3) — datetime
IMAGE (tb_image)
- ID (Key) — int — Primary key — NOT NULL
- POSTER_ID (Key2) — int — Foreign key → POSTER.ID — NOT NULL
- IMAGE_URL (Field) — varcher(255)
- CREATE_AT (Field2) — datetime
- MODIFYED_AT (Field3) — datetime
LIKES (tb_likes)
- ID (Key) — int — Foreign key → POSTER.ID — NOT NULL
- USER_ID (Key2) — int — Foreign key → POSTER.USER_ID — NOT NULL
- CREATE_AT (Field) — datetime
- MODIFYED_AT (Field2) — datetime
POSTER (tb_poster)
- ID (Key) — int — Primary key — NOT NULL
- USER_ID (Key2) — int — Foreign key → USER.ID — NOT NULL
- CONTENTS (Field) — varcher(255)
- CREATE_AT (Field2) — datatime
- MODIFYED_AT (Field3) — datetime
USER (tb_user)
- ID (Key) — int — Primary key — NOT NULL
- EMAIL (Field) — varcher(25)
- PASSWORD (Field2) — varcher(25)
- NICKNAME (Field3) — varcher(25)
- PHONE (Field4) — varcher(25)
- CREATE_AT (Field5) — datetime
- MODIFYED_AT (Field6) — datetime