길드_모델링
테이블 (9)
bingo_slot_data (Untitled)
- binggo_id (Key) — 기본 키 — NOT NULL
- slot_number (Field8)
- slot_grade (Field)
- condition_lv (Field2)
- condition_star (Field3)
- condition_sub_star (Field4)
- condition_evolve (Field5)
- condition_skill_A (Field6)
- condition_research_lv (Field7)
guild
- guild_base_id (Key) — int(11) — 기본 키 — NOT NULL
- guild_vice_master_cnt (Field) — int(11)
- item_req_cnt (Field2) — int(11)
- today_item_req_cnt (Field3) — int(11)
- binggo_req_cnt (Field4) — int(11)
- today_binggo_req_cnt (Field5) — int(11)
- send_cnt (Field6) — INT(11)
- today_send_cnt (Field7) — INT(11)
guild_lv
- lv (Key) — int — 기본 키 — NOT NULL
- need_exp (Field2) — int(11)
user_binggo
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Field) — varchar(10)
- slot_1 (Field2) — int(11)
- slot_2 (Field3) — int(11)
- slot_3 (Field4) — int(11)
- slot_4 (Field5) — int(11)
- slot_5 (Field6) — int(11)
- slot_6 (Field7) — int(11)
- slot_7 (Field9) — int(11)
- slot_8 (Field8) — int(11)
- slot_9 (Field10) — int(11)
- binggo_id (Key2) — 외래 키 → bingo_slot_data.binggo_id — NOT NULL
user_guild
- guild_id (Key3) — bigint — 기본 키 — NOT NULL
- guild_name (name) — varchar(8)
- introduce_text — varchar(200)
- emblem_idx — int(11)
- join_type — int(11)
- join_point — int(11)
- exp — int(11)
- create_date — datetime
- people_cnt — int(11)
- master_id — varchar(10)
- lv (Key) — int(11) — 외래 키 → guild_lv.lv — NOT NULL
- guild_base_id (Key2) — int(11) — 외래 키 → guild.guild_base_id — NOT NULL
user_guild_join
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
- nickname (Field2) — VARCHAR(20)
- call_time (Field3) — datetime
- guild_id (Key3) — bigint — 외래 키 → user_guild.guild_id — NOT NULL
user_guild_leave
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
- guild_name (Field) — char(8)
- guild_posion (Field3) — int(11)
- leave_time (Field4) — datetime
- join_time (Field5) — datetime
- last_login_time (Field6) — datetime
- guild_id (Key3) — bigint — 외래 키 → user_guild.guild_id — NOT NULL
user_guild_message
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
- type (Field) — char(1)
- write_time (Field2) — datetime
- remain_time (Field3) — datetime
- text (Field4) — text
- item_id (Field5) — int(11)
- item_req_cnt (Field6) — int(11)
- item_send_cnt (Field7) — int(11)
- reward_exp (Field9) — int(11)
- reward_gold (Field10) — int(11)
- reward_item_id (Field11) — int(11)
- reward_item_cnt (Field12) — int(11)
- guild_id (Key32) — bigint — 외래 키 → user_guild.guild_id — NOT NULL
- binggo_id (Key3) — 외래 키 → bingo_slot_data.binggo_id — NOT NULL
user_guild_people
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — varchar(10) — 기본 키 — NOT NULL
- guild_position (Field2) — char(1)
- guild_attendance (Field) — int(11)
- attendance_degree (Field3) — int(11)
- join_time (Field4) — datetime
- last_login_time (Field5) — datetime
- today_item_req_cnt (Field7) — int(11)
- today_binggo_req_cnt (Field6) — int(11)
- today_send_cnt (Field9) — int(11)
- guild_id (Key32) — bigint — 외래 키 → user_guild.guild_id — NOT NULL