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`