f
Tables (7)
Chat
- c_id — int — Primary key — NOT NULL
- userid — nvarchar(50) — Foreign key → ord_user.u_id
- c_detail — nvarchar(max)
Rule
- r_id — int — Primary key — NOT NULL
- r_name — nvarchar(50)
Schedule
- s_id — int — Primary key — NOT NULL
- s_name (u_id) — nvarchar(50) — Foreign key → ord_user.u_no — NOT NULL
- s_date — date — NOT NULL
- use_rule — int — NOT NULL
gameinfo
- g_id — int — Primary key — NOT NULL
- g_name — nvarchar(50)
- Maxspeed (m_s) — int
- Maxdefense (m_d) — int
ord_user
- u_no — int — Primary key — NOT NULL
- u_id — nvarchar(50) — NOT NULL
- u_pw — nvarchar(50) — NOT NULL
- account_created_date — datetime — NOT NULL
- u_admin — bit — NOT NULL
record
- r_id — int — Primary key — NOT NULL
- u_id — nvarchar(50) — Foreign key → ord_user.u_id
- game_result — bit
- pro — nvarchar(50)
- score — int
- last_count — int
unit_table
- u_name — varchar(255) — Primary key — NOT NULL
- u_pro — varchar(255) — NOT NULL
- u_dd — int — NOT NULL
- u_sd — int — NOT NULL
- u_mds — int — NOT NULL
- u_au — int — NOT NULL