OS
Tables (18)
Auth.cidi (Untitled2)
- Key (cidi_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
- Field (ci) — VARCHAR(88)
- Field (di) — VARCHAR(64)
Auth.password (Untitled3)
- Key (password_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
- Field (salt) — VARCHAR(128)
- Field (password) — VARCHAT(128)
- Field (update_date) — DATETIME
Auth.social_login (Auth)
- Key (social_login_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
- Field (social_code) — UNSIGNED INT
- Field (access_token) — VARCHAR(256)
- Field (update_date) — DATETIME
Copy Of member.user (CopyOfUntitled)
- Key (user_no) — UNSIGNED INT — Primary key — NOT NULL
- Field (user_name)
log.login_log (Untitled8)
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
- Field (fail_count) — UNSIGNED INT
- Field (fail_reason) — UNSIGNED INT
- Field (ip) — UNSIGNED INT
- Field (status_code) — UNSIGNED INT
member.authertication (Untitled7)
- Key (authentication_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
- Field (email) — VARCHARR(30)
- Field (sex) — UNSIGNED INT
- Field (auth_data) — DATETIME
- Field (gather_agree) — UNSIGNED INT
- Field (cell_phone) — VARCHAR(30)
- Field (birthday) — VARCHAR(128)
member.profile (Untitled4)
- Key (profile_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
- Field (nickname) — VARCHAR(100)
member.profile_skillStack (Untitled6)
- Key (profile_id) — UNSIGNED INT — Foreign key → member.profile.Key — NOT NULL
- Key (skillStack_id) — UNSIGNED_INT — Foreign key → member.skillStack.Key — NOT NULL
member.skillStack (Untitled5)
- Key (skillStack_id) — UNSIGNED_INT — Primary key — NOT NULL
- Field (skill) — VARCHAR(15)
member.user (Untitled)
- Key (user_no) — UNSIGNED INT — Primary key — NOT NULL
- Field (user_name)
page.category (Untitled13)
page.page_userPost (Untitled12)
- Key (page_userPost_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (page_id) — UNSIGNED INT — Foreign key → page.project.Key — NOT NULL
page.project (Untitled11)
- Key (page_id) — UNSIGNED INT — Primary key — NOT NULL
- Field (display_count) — UNSIGNED INT
- Field (page_number) — UNSIGNED INT
post (Untitled9)
- Key (post_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
user.ownedItem (Untitled14)
- Key (ownedItem_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → member.user.Key — NOT NULL
- Field (hair) — UNSIGNED INT
- Field (eye) — UNSGINED INT
- Field (effect) — UNSIGNED INT
user_enteredUser (Untitled16)
- Key (enteredUser_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (user_postIn_id) — UNSIGNED INT — Foreign key → user_postInner.Key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → Copy Of member.user.Key — NOT NULL
user_postInner (Untitled10)
- Key (user_postIn_id) — UNSIGNED INT — Primary key — NOT NULL
- Key (post_id) — UNSIGNED INT — Foreign key → post.Key — NOT NULL
- Field (title) — VARCHAR(128)
- Field (body) — VARCHAR(1028)
- Field (upload_date) — DATETIME
- Field (recruit_total) — UNSIGNED INT
- Field (entered_count) — UNSIGNED INT
user_postOutter (Untitled15)
- Key (user_postOut_id) — Primary key — NOT NULL
- Key (post_id) — UNSIGNED INT — Foreign key → post.Key — NOT NULL
- Key (user_no) — UNSIGNED INT — Foreign key → Copy Of member.user.Key — NOT NULL
- Field (Title) — VARCHAR(128)