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