khuromise

Tables (4)

board (약속 내용)

  • id (Key) — Integer — Primary key — NOT NULL
  • title (Field) — String
  • content (Field2) — String
  • category (Field3) — String
  • genderdisplay (Field4) — String
  • date (Field5) — String
  • noon (Field6) — String
  • hour (Field7) — String
  • minute (Field8) — String
  • placename (Field9) — String
  • position (Field10) — String
  • currentpeople (Field11) — Integer
  • maxpeople (Field12) — Integer

comment (댓글 글 내용)

  • id (Key) — Integer — Primary key — NOT NULL
  • postid (Field) — String
  • writerid (Field2) — String
  • writername (Field3) — String
  • comment (Field4) — String

user (user의 개인 정보)

  • id (Key) — Integer — Primary key — NOT NULL
  • userid (Field) — String
  • userpw (Field2) — String
  • username (Field3) — String
  • usergender (Field4) — String
  • userbirthday (Field5) — String
  • useremail (Field6) — String

userapply (특정 post 댓글)

  • id (Key) — Integer — Primary key — NOT NULL
  • postid (Field) — String
  • userid (Field2) — String