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)