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