pinpal
Tables (9)
bowling_center
- bowling_center_id — bigint — Primary key — NOT NULL
- name (Field) — varchar(30)
- address — varchar(50)
- description — text
ceremony
- ceremony_id — bigint(20) — Primary key — NOT NULL
- avg_1st — bigint(20)
- grade1_1st — bigint(20)
- grade2_1st — bigint(20)
- grade3_1st — bigint(20)
- grade4_1st — bigint(20)
- high_score_girl — bigint(20)
- high_score_man — bigint(20)
- total_1st — bigint(20)
- club_id — bigint(20) — Foreign key → club_mst.club_id
- game_id — bigint(20) — Foreign key → game.game_id
ceremony_team_1st
- ceremony_id — bigint(20) — Foreign key → ceremony.ceremony_id — NOT NULL
- team_1st_id — bigint(20)
club_dtl
- no — bigint(20) — Primary key — NOT NULL
- avg — int(11)
- create_date — datetime(6)
- grade — int(11)
- role — varchar(255)
- update_date — datetime(6)
- club_id — bigint(20) — Foreign key → club_mst.club_id
- member_id — bigint(20) — Foreign key → member.member_id
club_mst
- club_id — bigint(20) — Primary key — NOT NULL
- create_date — datetime(6)
- description — text
- name — varchar(255)
- update_date — datetime(6)
- bowling_center_id — bigint — Foreign key → bowling_center.bowling_center_id — NOT NULL
game
- game_id — bigint(20) — Primary key — NOT NULL
- confirmed_code — varchar(255)
- create_date — datetime(6)
- date — date
- name — varchar(255)
- score_counting — bit(1)
- status — varchar(255)
- time — time
- type — varchar(255)
- update_date — datetime(6)
- club_id — bigint(20) — Foreign key → club_mst.club_id
- deleted — int(11)
- bowling_center_id — bigint — Foreign key → bowling_center.bowling_center_id — NOT NULL
member
- member_id — bigint(20) — Primary key — NOT NULL
- birth — varchar(255)
- create_date — datetime(6)
- email — varchar(255)
- gender — int(11) — NOT NULL
- join_path — varchar(255)
- name — varchar(255)
- password — varchar(255)
- profile — varchar(255)
- roles — varchar(255)
- sns_id — varchar(255)
- status — varchar(255)
- update_date — datetime(6)
member_dtl
- member_id — bigint(20) — Foreign key → member.member_id — NOT NULL
- phone — varchar(255)
scoreboard
- scoreboard_id — bigint(20) — Primary key — NOT NULL
- all_cover — int(11) — NOT NULL
- confirmed_join — bit(1)
- create_date — datetime(6)
- game_1 — int(11)
- game_2 — int(11)
- game_3 — int(11)
- game_4 — int(11)
- grade — int(11)
- member_avg — int(11)
- member_profile — varchar(255)
- side_avg — bit(1)
- side_grade1 — bit(1)
- status — varchar(255)
- team_number — int(11)
- update_date — datetime(6)
- game_id — bigint(20) — Foreign key → game.game_id
- member_id — bigint(20) — Foreign key → member.member_id