portfolias
Tables (10)
CAREER (tbl_user_career)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.id — NOT NULL
- title (Field)
- contents (c)
- created_at (Field2)
- updated_at (Field3)
COMMENT (tbl_contents_comment)
- id (Key) — Primary key — NOT NULL
- content_id (Key2) — Foreign key → CONTENTS.id — NOT NULL
- user_id (Key3) — Foreign key → USER.id — NOT NULL
- comment (Field)
- created_at (Field2)
- updated_at (Field3)
COMPANY (tbl_user_company)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.id — NOT NULL
- name (Field)
- career (Field2)
- major (Field3)
- created_at (Field4)
- updated_at (Field5)
CONTENTS (tbl_contents)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.id — NOT NULL
- titlte (Field)
- contents (Field2)
- created_at (Field3)
- updated_at (Field4)
FOLLOW (tbl_user_follow)
- id (Key) — Primary key — NOT NULL
- to_user (Key222) — Foreign key — NOT NULL
- created_at (Field)
- updated_at (Field2)
LIKE (tbl_user_like)
- id (Key) — Primary key — NOT NULL
- user_id (Key2) — Foreign key → USER.id — NOT NULL
- content_id (Key3) — Foreign key → CONTENTS.id — NOT NULL
- id (Key22) — Foreign key → CONTENTS.user_id — NOT NULL
- created_at (Field)
- updated_at (Field2)
SCHOOL (tbl_user_school)
- id (Key) — Primary key — NOT NULL
- user_id (Key3) — Foreign key → USER.id — NOT NULL
- name (Field)
- major (Field2)
- status (Field3)
- created_at (Field4)
- updated_at (Field5)
STACK (tbl_user_stack)
- id (Key) — Primary key — NOT NULL
- user_id (Key3) — Foreign key → USER.id — NOT NULL
- name (Field)
- level (Field2)
- created_at (Field3)
- updated_at (Field4)
SUB_COMMENT (tbl_sub_comment)
- Key3 — Primary key — NOT NULL
- comment_id (Key) — Foreign key → COMMENT.id — NOT NULL
- user_id (Key2) — Foreign key → USER.id — NOT NULL
- comment (Field)
- created_at (Field2)
- updated_at (Field3)
USER (tbl_user)
- id (Key) — Primary key — NOT NULL
- username (Field) — text
- name (Field2) — text
- phone (Field3) — text
- password (Field4) — text
- token (Field5) — text
- created_at (Field6)
- updated_at (Field7)