aboutme
Tables (13)
Default (Default.Enquery)
- seq — bigint — Primary key — NOT NULL
- Field4 (type) — tinyint(1) — NOT NULL
- Field6 (color) — tinyint(1) — NOT NULL
- Field7 (theme) — tinyint(1)
- Field (question) — varchar(100) — NOT NULL
- Field2 (sort) — int
- Field (reg_date) — datetime — NOT NULL
Default (Default.Reason_List)
- seq — bigint — Primary key — NOT NULL
- Field4 (reason) — varchar(100) — NOT NULL
- Field (reg_date) — datetime — NOT NULL
QnA (QnA.SelfQuest)
- seq — bigint — Primary key — NOT NULL
- seq (p_seq) — bigint — Foreign key → QnA.seq — NOT NULL
- seq (author_id) — bigint — Foreign key → User.seq — NOT NULL
- seq (sort) — bigint — Foreign key → Default.seq
- Field6 (title) — varchar(100)
- Field7 (answer) — text
- Field4 (theme) — tinyint(1)
- Field (reg_date) — date — NOT NULL
- Field2 (update_date) — date — NOT NULL
QnA (QnA.Tags)
- seq — bigint — Primary key — NOT NULL
- Field4 (tag_name) — varchar(30) — NOT NULL
- Field (reg_date) — datetime — NOT NULL
QnA (QnA.Category_Tags)
- seq (tag_seq) — bigint — Foreign key → QnA.seq — NOT NULL
- Key (category_level_seq) — bigint — Foreign key → QnA.Key — NOT NULL
QnA (QnA.Comment)
- seq — bigint — Primary key — NOT NULL
- seq (user_id) — bigint — Foreign key → User.seq — NOT NULL
- seq (author_id) — bigint — Foreign key → User.seq — NOT NULL
- Key (category_level_id) — bigint — Foreign key → QnA.Key — NOT NULL
- Field4 (user_comment) — varchar(255) — NOT NULL
- Field (reg_date) — date — NOT NULL
QnA (QnA.Category)
- Key (seq) — bigint — Primary key — NOT NULL
- seq (author_id) — bigint — Foreign key → User.seq — NOT NULL
- seq (title_id) — bigint — Foreign key → Default.seq — NOT NULL
- Field (color) — tinyint(1) — NOT NULL
QnA (Like_Info)
- seq — bigint — Primary key — NOT NULL
- Key (category_level_id) — bigint — Foreign key → QnA.Key — NOT NULL
- seq (author_id) — bigint — Foreign key → User.seq — NOT NULL
- seq (like_user) — bigint — Foreign key → User.seq — NOT NULL
- Field (like_yn) — varchar(2)
- seq (scrap_user) — bigint — Foreign key → User.seq — NOT NULL
- Field (scrap_yn) — varchar(2)
- Field (reg_date) — datetime — NOT NULL
- Field (update_date) — datetime — NOT NULL
QnA (QnA.Category_Level)
- Key (seq) — bigint — Primary key — NOT NULL
- Key (category_id) — bigint — Foreign key → QnA.Key — NOT NULL
- Field (answer) — text — NOT NULL
- Field (level) — int — NOT NULL
- Field (share_yn) — varchar(2) — NOT NULL
- Field (likes) — int — NOT NULL
- Field (scraps) — int — NOT NULL
- Field (reg_date) — datetime — NOT NULL
- Field (update_date) — datetime — NOT NULL
User (User.User_Info)
- seq — bigint — Primary key — NOT NULL
- Field3 (email) — varchar(30) — NOT NULL
- Field4 (name) — varchar(20) — NOT NULL
- Field5 (gender) — tinyint(1) — NOT NULL
- Field6 (login_type) — VARCHAR(2) — NOT NULL
- Field7 (auth_yn) — tinyint(1) — NOT NULL
- Field3 (last_login) — datetime
- Field (reg_date) — date — NOT NULL
- Field2 (update_date) — date — NOT NULL
- Field2 (access_token) — varchar(255)
User (User.VOC)
- Key (seq) — bigint — Primary key — NOT NULL
- seq (author_id) — bigint — Foreign key → User.seq — NOT NULL
- seq (reason_id) — bigint — Foreign key → Default.seq — NOT NULL
- Key (question_id) — bigint — Foreign key → QnA.Key — NOT NULL
- Field (regdate) — datetime — NOT NULL
User (User.Profile)
- Key (seq) — bigint — Primary key — NOT NULL
- seq (user_id) — bigint — Foreign key → User.seq — NOT NULL
- Field2 (introduce) — varchar(100)
- Field3 (nickname) — varchar(30)
- Field4 (color) — tinyint(1)
- Field5 (theme_comment) — tinyint(1)
- Field6 (push_yn) — varchar(2)
- Field7 (push_time) — time
- Field (reg_date) — datetime — NOT NULL
- Field (update_time) — datetime — NOT NULL
User (User.User_Level)
- Key (seq) — bigint — Primary key — NOT NULL
- seq (user_id) — bigint — Foreign key → User.seq — NOT NULL
- Field (color) — tinyint(1) — NOT NULL
- Field (level) — int — NOT NULL
- Field (experience) — int — NOT NULL