artisteb_Hejow_version2

Tables (11)

Untitled (User)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Field (Login_ID) — VARCHAR(20) — NOT NULL
  • Field2 (Password) — VARCHAR(100) — NOT NULL
  • Field3 (NickName) — VARCHAR(100) — NOT NULL
  • Field4 (Bio) — VARCHAR(255) — NOT NULL
  • Field5 (Picture) — VARCHAR(255)
  • Field6 (UserName) — VARCHAR(20) — NOT NULL
  • Field7 (Email) — VARCHAR(100) — NOT NULL
  • Field8 (PhoneNumber) — VARCHAR(20) — NOT NULL
  • Field9 (Birth) — DATETIME — NOT NULL
  • Field (Genre) — INT — NOT NULL
  • Field (Belong) — VARCHAR(20)
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Follow)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL
  • Key (Following_user_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (Followed_user_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (Badge)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (User_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Description) — VARCHAR(20)
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Liked_post)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (User_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (Post_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Post)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (User_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Title) — VARCHAR(255) — NOT NULL
  • Field (Content) — TEXT — NOT NULL
  • Field (Category) — VARCHAR(20) — NOT NULL
  • Field (Genre) — INT
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Post_file)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (Post_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Link) — TEXT — NOT NULL
  • Field (Create_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Chatting_room)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL
  • Key (Created_user_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (Invited_user_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL

Untitled (Chatting_message)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (Chatting_room_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Content) — TEXT — NOT NULL
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Chatting_room_file)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (Chatting_room_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Link) — TEXT — NOT NULL
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Comment)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (User_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (Post_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Content) — TEXT — NOT NULL
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL

Untitled (Comment_comment)

  • Key (ID) — Bigint — Primary key — NOT NULL
  • Key (User_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Key (Comment_ID) — Bigint — Foreign key → Untitled.Key — NOT NULL
  • Field (Content) — TEXT — NOT NULL
  • Field (Created_at) — DATETIME — NOT NULL
  • Field (Updated_at) — DATETIME — NOT NULL
  • Field (Status) — VARCHAR(10) — NOT NULL