SellingCommunity

Tables (6)

comment (Untitled4)

  • comment_id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • post_id (Key2) — VARCHAR(255) — Foreign key → communityPost.post_id — NOT NULL
  • user_id (Key3) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
  • content (Field) — TEXT — NOT NULL

communityPost (Untitled2)

  • post_id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
  • title (Field) — VARCHAR(100) — NOT NULL
  • content (Field2) — TEXT — NOT NULL
  • image (Field3) — VARCHAR(255)

like (Untitled5)

  • like_id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
  • post_id (Key3) — VARCHAR(255) — Foreign key → communityPost.post_id — NOT NULL
  • like_time (Field) — DATETIME — NOT NULL

purchase (Untitled6)

  • puchase_id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
  • sale_id (Key3) — VARCHAR(255) — Foreign key → selling_board.sale_id — NOT NULL
  • purchae_date (Field) — DATETIME — NOT NULL
  • quantity (Field2) — INT — NOT NULL

selling_board (Untitled3)

  • sale_id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • user_id (Key2) — VARCHAR(255) — Foreign key → user.user_id — NOT NULL
  • user_id (Field2) — VARCHAR(255) — NOT NULL
  • title (Field3) — VARCHAR(255) — NOT NULL
  • content (Field4) — TEXT — NOT NULL
  • image (Field) — VARCHAR(255)

user (Untitled)

  • user_id (Key) — VARCHAR(255) — Primary key — NOT NULL
  • username (Field) — VARCHAR(30) — NOT NULL
  • password (Field2) — VARCHAR(100) — NOT NULL
  • name (Field3) — VARCHAR(50) — NOT NULL
  • age (Field4) — INT — NOT NULL
  • address (Field5) — NOT NULL