soomgo

Tables (8)

category

  • CategoryNum — INT — Primary key — NOT NULL
  • Id — INT
  • P_Id — INT
  • CategoryName — VARCHAR(20)

community_board

  • cb_no — INT — Primary key — NOT NULL
  • board_no — TINYINT
  • cb_title — VARCHAR (50)
  • cb_content — LONGTEXT
  • cb_file — VARCHAR(2500)
  • user_num — INT
  • CategoryNum — INT
  • cb_addr — VARCHAR(50)
  • cb_currentview — INT
  • cb_like — INT
  • cb_regdate — DATETIME

community_reply

  • cr_no — INT — Primary key — NOT NULL
  • cb_no — INT
  • cr_content — LONGTEXT
  • cr_file — VARCHAR(2500)
  • user_num — INT
  • cr_like — INT
  • cr_regdate — DATETIME

expert (고수유저)

  • expert_num — INT — Primary key — NOT NULL
  • user_num — INT
  • CategoryNum — INT
  • experience_years — INT
  • education — INT
  • img — JSON
  • rating — FLOAT

request_newbie

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5
  • Field6
  • Field7
  • Field8
  • Field9
  • Field10
  • Field11
  • Field12
  • Field13
  • Field14
  • Field15
  • Field16
  • Field17
  • Field18
  • Field19
  • Field20

session

  • session_id — INT — Primary key — NOT NULL
  • user_num — INT
  • session_token — VARCHAR(255)
  • created — TIMESTAMP
  • expires — TIMESTAMP

user (유저)

  • user_num — INT — Primary key — NOT NULL
  • user_email — INT
  • user_password — VARCHAR(30)
  • user_name — VARCHAR(10)
  • user_phonenum — VARCHAR(15)
  • user_type — ENUM
  • create_at — TIMESTAMP
  • user_sex — ENUM

user_profile (유저프로필)

  • profile_id — INT — Primary key — NOT NULL
  • user_num — INT
  • user_nickname — VARCHAR(20)
  • user_addr — VARCHAR(30)
  • profile_img — JSON
  • introduce — TEXT