sqld
Tables (9)
Untitled7 (user)
- Key (user_id) — INT — Primary key — NOT NULL
- Field (u_id) — INT — Primary key
- Field (u_password) — VARCHER(15) — Primary key
- Field (u_mobile) — INT — Primary key
- Field (u_email) — VARCHER(15) — Primary key
- Field (u_name) — VARCHER(50)
- Field (u_nickname) — VARCHER(15)
- Key (chat_id) — INT — Foreign key → Untitled7.Key — NOT NULL
Untitled7 (chat)
- Key (chat_id) — INT — Primary key — NOT NULL
- Field (chattime)
Untitled7 (signup)
- Key (signup_id) — INT — Primary key — NOT NULL
- Key (user_id) — INT — Foreign key → Untitled7.Key — NOT NULL
- Field (u_id) — INT — Foreign key → Untitled7.Field
- Field (u_password) — VARCHER(15) — Foreign key → Untitled7.Field
- Field (u_mobile) — INT — Foreign key → Untitled7.Field
- Field (u_email) — VARCHER(15) — Foreign key → Untitled7.Field
- Field (argeement) — VARCHER(50)
board (Untitled)
- b_id (Key) — INT — Primary key — NOT NULL
- b_title (Field) — VARCHER (50)
- b_content (Field2) — TEXT
- b_author (Field3) — VARCHER (15)
- b_createdAt (Field4) — DATE
- b_updatedAt (Field5) — DATE
- b_hit (Field6) — INT
board (Untitled4)
- board_id (Key) — INT — Primary key — NOT NULL
- user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL
- board_title (Field) — VARCHER (50)
- board_content (Field2) — VARCHER (50)
- board_createdAt (Field3) — DATE
- board_updateAt (Field4) — DATE
- board_hit (Field5) — INT
boardlike (Untitled6)
- board_id (Key) — INT — Foreign key → board.board_id — NOT NULL
- user_id (Key2) — INT — Foreign key → board.user_id — NOT NULL
- user_id (Key3) — INT — Foreign key → user.user_id — NOT NULL
comment (Untitled2)
- c_id (Key) — INT — Primary key — NOT NULL
- c_content (Field) — TEXT
- c_createdAt (Field2) — DATE
- c_updatedAt (Field3) — DATE
- b_id (Key2) — INT — Foreign key → board.b_id — NOT NULL
comment (Untitled5)
- c_id (Key) — INT — Primary key — NOT NULL
- c_content (Field) — VARCHER (50)
- c_author (Field2) — VARCHER (15)
- user_id (Key2) — INT — Foreign key → user.user_id — NOT NULL
- board_id (Key3) — INT — Foreign key → board.board_id — NOT NULL
- user_id (Key22) — INT — Foreign key → board.user_id — NOT NULL
user (Untitled3)
- user_id (Key) — INT — Primary key — NOT NULL
- u_name (Field) — VARCHER (50)
- u_nickname (Field2) — VARCHER (15)
- u_id (Field3) — INT
- u_password (Field4) — VARCHER (15)
- u_joinedAt (Field5) — DATE
- u_mobile (Field6) — INT
- u_email (Field7) — VARCHER (15)