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