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