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)