pilot

Tables (4)

like_to

  • lno — bigint — Primary key
  • pno (pno2) — bigint — Foreign key → post.pno
  • uno (uno2) — bigint — Foreign key → post.uno
  • pno — bigint — NOT NULL
  • uno — bigint — NOT NULL

post

  • pno — bigint — Primary key
  • uno (uno2) — bigint — Foreign key → user.uno
  • create_date — timestamp
  • modified_date — timestamp
  • image_path — varchar(250)
  • like_count — integer
  • music_path — varchar(250)
  • title — varchar(500) — NOT NULL
  • uno — bigint — NOT NULL
  • content — Text — NOT NULL

reply

  • rno — bigint — Primary key
  • pno (pno2) — bigint — Foreign key → post.pno
  • uno (uno2) — bigint — Foreign key → post.uno
  • uno (uno3) — bigint — Foreign key → user.uno
  • create_date — timestamp
  • modified_date — timestamp
  • content — Text
  • image_path — varchar(255)
  • parent — integer
  • pno — bigint — NOT NULL
  • state — boolean
  • uno — bigint — NOT NULL

user

  • uno — bigint — Primary key
  • create_date — timestamp
  • modified_date — timestamp
  • email — varchar(255) — NOT NULL
  • nickname — varchar(255) — NOT NULL
  • password — varchar(255) — NOT NULL