GetTogether

Tables (5)

club

  • no — INT — Primary key — NOT NULL
  • clubid — VARCHAR(45) — NOT NULL
  • clubadmin — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • clubpost — INT — NOT NULL
  • clubmember — INT — NOT NULL
  • createdate — DATETIME — NOT NULL
  • clubthumbnail — VARCHAR(200)
  • clubnotice — VARCHAR(200)
  • description — VARCHAR(200) — NOT NULL
  • ispublic — TINYINT — NOT NULL
  • INDEX — `fk_club_member1_idx`

clubinvite

  • no — INT — Primary key — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid — NOT NULL
  • username — VARCHAR(45) — NOT NULL
  • clubno — INT — Foreign key → club.no — NOT NULL
  • clubid — VARCHAR(45) — NOT NULL
  • invite — TINYINT — NOT NULL
  • submit — TINYINT — NOT NULL
  • complete — INT — NOT NULL
  • createdate — DATETIME — NOT NULL
  • INDEX — `fk_ClubInviteVO_member1_idx`
  • INDEX — `fk_ClubInviteVO_club1_idx`

clubmember

  • no — INT — Primary key — NOT NULL
  • clubno — INT — Foreign key → club.no — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid
  • clubid — VARCHAR(45) — NOT NULL
  • username — VARCHAR(45) — NOT NULL
  • joindate — DATETIME — NOT NULL
  • INDEX — `fk_clubmember_member1_idx`
  • INDEX — `fk_clubmember_club1_idx`

member

  • userid — VARCHAR(45) — Primary key — NOT NULL
  • userpassword — VARCHAR(45) — NOT NULL
  • username — VARCHAR(45) — NOT NULL
  • writedate — DATETIME — NOT NULL

review

  • no — INT — Primary key — NOT NULL
  • clubno — INT — Foreign key → club.no — NOT NULL
  • userid — VARCHAR(45) — Foreign key → member.userid
  • username — VARCHAR(45) — NOT NULL
  • writedate — DATETIME — NOT NULL
  • hit — INT — NOT NULL
  • subject — VARCHAR(200) — NOT NULL
  • content — LONGTEXT — NOT NULL
  • ip — VARCHAR(45) — NOT NULL
  • people — INT — NOT NULL
  • link — VARCHAR(200) — NOT NULL
  • visitdate — VARCHAR(45) — NOT NULL
  • location — VARCHAR(200) — NOT NULL
  • revisit — TINYINT — NOT NULL
  • score — FLOAT — NOT NULL
  • INDEX — `fk_board_club1_idx`
  • INDEX — `fk_board_member1_idx`