Anabada

Tables (3)

Comment (comment)

  • comment_ID (Key) — Long — Primary key — NOT NULL
  • post_ID (Key2) — Long — Foreign key → Post.post_ID — NOT NULL
  • User_id (Key22) — Long — Foreign key → Post.User_id — NOT NULL
  • content (Field) — String

Post (Post_ID)

  • post_ID (Key) — Long — Primary key — NOT NULL
  • User_id (Key2) — Long — Foreign key → User.User_id — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • price (Field3) — Long
  • imageUrl (Field4) — String
  • count (Field5) — int
  • modifiedAt (Field6) — String
  • createdAt (Field7) — String
  • category (Field8) — Long

User

  • User_id (Key) — Long — Primary key — NOT NULL
  • nickname (Field) — String
  • password (Field2) — int
  • phoneNumber (Field3) — String