kodupERD
Tables (30)
ban_history
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- ban_number — int — NOT NULL
- ban_date — datetime — NOT NULL
bank
- bank_sno — int — Primary key — NOT NULL
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- bank_name — varchar(255) — NOT NULL
- account_holder — varchar(255) — NOT NULL
- account — varchar(255) — NOT NULL
career_certification
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- career_certificate — varchar(255) — NOT NULL
certification_date
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- certification_category — varchar(255) — NOT NULL
- apply_date — datetime — NOT NULL
chat
- chat_sno — int — Primary key — NOT NULL
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- chat_status — int — NOT NULL
- grade — int — NOT NULL
corperation
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- corp_license — varchar(255) — NOT NULL
- corp_logo — varchar(255) — NOT NULL
- corp_name — varchar(255) — NOT NULL
- corp_phone — varchar(255) — NOT NULL
- corp_email — varchar(255) — NOT NULL
- manager_name — varchar(255) — NOT NULL
- manager_phone — varchar(255) — NOT NULL
- manager_email — varchar(255) — NOT NULL
countvisitors
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- nal — datetime
freetalking_board
- freetalking_sno — int — Primary key — NOT NULL
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- freetalking_horsehead — varchar(255) — NOT NULL
infoshare_board
- infoshare_sno — int — Primary key — NOT NULL
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- infoshare_horsehead — varchar(255) — NOT NULL
jobsearch_board
- jobsearch_sno — int — Primary key — NOT NULL
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- jobsearch_horsehead — varchar(255) — NOT NULL
kodupbudget
- budget — int
mansearch_board
- mansearch_sno — int — Primary key — NOT NULL
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- work_start — date — NOT NULL
- pay — int — NOT NULL
- corp_location — varchar(255) — NOT NULL
- position — varchar(100) — NOT NULL
- job_type — varchar(100) — NOT NULL
- required_career — varchar(100) — NOT NULL
- education_level — varchar(255) — NOT NULL
- work_type — varchar(255) — NOT NULL
- pay_date — varchar(255) — NOT NULL
- required_skill — varchar(255) — NOT NULL
- deadline — date — NOT NULL
- main_task — varchar(255) — NOT NULL
- sub_task — varchar(255) — NOT NULL
mantoman
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- roomCode — varchar(255) — Foreign key → mantoman_room.roomCode — NOT NULL
- your_id — varchar(255) — NOT NULL
mantoman_att
- roomCode — varchar(255) — Foreign key → mantoman_room.roomCode — NOT NULL
- sysfile — varchar(255) — NOT NULL
mantoman_room
- roomCode — varchar(255) — Primary key — NOT NULL
- doc — longtext
- last_talktime — datetime — NOT NULL
- last_talk — varchar(255)
- mantoman_pixel_reward — int — NOT NULL
member_introduce
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- introduce — longtext
notification_board
- notification_sno — int — Primary key — NOT NULL
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- notification_horsehead — varchar(255) — NOT NULL
pixel_buy_list
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- Field — VARCHAR(255)
- pixel_buy_date — datetime — NOT NULL
- pixel_buy_amount — int — NOT NULL
pixel_exchange_list
- pixel_exchange_list_sno — int — Primary key — NOT NULL
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- apply_date — datetime — NOT NULL
- apply_pixel — int — NOT NULL
- pixel_exchange_status — int — NOT NULL
pixel_exchange_rate
- normal — decimal(10,2) — NOT NULL
- personal — decimal(10,2) — NOT NULL
- plus — decimal(10,2) — NOT NULL
- partner — decimal(10,2) — NOT NULL
pixel_history
- pixel_history_sno — int — Primary key — NOT NULL
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- pixel_log — int — NOT NULL
- history_date — datetime — NOT NULL
- history_detail — varchar(255) — NOT NULL
pixel_price
- pixel_1_price — int — NOT NULL
- pixel_1_amount — int — NOT NULL
- pixel_2_price — int — NOT NULL
- pixel_2_amount — int — NOT NULL
- pixel_3_price — int — NOT NULL
- pixel_3_amount — int — NOT NULL
- pixel_4_price — int — NOT NULL
- pixel_4_amount — int — NOT NULL
- pixel_5_price — int — NOT NULL
- pixel_5_amount — int — NOT NULL
- pixel_6_price — int — NOT NULL
- pixel_6_amount — int — NOT NULL
premium_review
- premium_review_sno — int — Primary key — NOT NULL
- mansearch_sno — int — Foreign key → mansearch_board.mansearch_sno — NOT NULL
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- review — longtext — NOT NULL
premium_review_buylist
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- premium_review_sno — int — Foreign key → premium_review.premium_review_sno — NOT NULL
qna_board
- qna_sno — int — Primary key — NOT NULL
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- qna_pixel_reward — int — NOT NULL
- qna_horsehead — varchar(255) — NOT NULL
- qna_status — int — NOT NULL
repl
- repl_sno — int — Primary key — NOT NULL
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- grp — int — NOT NULL
- seq — int — NOT NULL
- deep — int — NOT NULL
- repl_nal — datetime — NOT NULL
- repl_doc — longtext — NOT NULL
- thumbup — int — NOT NULL
- thumbdown — int — NOT NULL
- repl_delete — int — NOT NULL
repl_selected
- repl_sno — int — Foreign key → repl.repl_sno — NOT NULL
- repl_status — int — NOT NULL
view_board
- sno — int — Foreign key → 게시판공통컬럼.sno — NOT NULL
- id — varchar(255) — Foreign key → 게시판공통컬럼.id — NOT NULL
게시판공통컬럼 (board)
- sno — int — Primary key — NOT NULL
- id — varchar(255) — Foreign key → 회원정보.id — NOT NULL
- boardtype — varchar(100) — NOT NULL
- nal — datetime — NOT NULL
- subject — varchar(255) — NOT NULL
- doc — longtext — NOT NULL
- hashtag — varchar(255)
- viewcount — int — NOT NULL
- thumbup — int — NOT NULL
- thumbdown — int — NOT NULL
- board_delete — int — NOT NULL
회원정보 (member)
- id — varchar(255) — Primary key — NOT NULL
- pwd — varchar(255)
- email — varchar(255) — NOT NULL
- nickname — varchar(255) — NOT NULL
- gender — varchar(50) — NOT NULL
- age — int — NOT NULL
- profile_img — varchar(255) — NOT NULL
- account_type — int — NOT NULL
- ban_status — int — NOT NULL
- pixel — int — NOT NULL
- grade — int — NOT NULL
- join_date — datetime — NOT NULL
- email_status — int — NOT NULL
- mento_status — int — NOT NULL
- corp_status — int — NOT NULL