spring

Tables (3)

Comment (Untitled5)

  • comment_no (PK) — int — Primary key — NOT NULL
  • user_id (FK(user)) — int
  • post_no (FK(post)) — int
  • cotent (Field) — String
  • reg_date (Field2) — String
  • user_no (PK2) — int — Foreign key → User.user_no — NOT NULL
  • post_no (PK3) — int — Foreign key → Post.post_no — NOT NULL

Post (Untitled)

  • post_no (PK) — int — Primary key — NOT NULL
  • writer (Field2) — String
  • password (Field3) — String
  • content (Field4) — String
  • hit (Field5) — int
  • ref (Field6) — int
  • pnum (Field7) — int
  • step (Field8) — int
  • lev (Field9) — int
  • reply (Field10) — int
  • reg_date (Field11) — String
  • user_no (PK2) — int — Foreign key → User.user_no — NOT NULL

User (Untitled3)

  • user_no (PK) — int — Primary key — NOT NULL
  • id (Field) — String
  • password (Field2) — String
  • nickname (Field3) — String