rams erd

Tables (9)

category (카테고리)

  • cate_seq — int(20) — Primary key — NOT NULL
  • cate_user_seq — int(20)
  • cate_company_seq — int(20)
  • cate_ref_seq — int(20)
  • cate_depth — tinyint(20)
  • cate_name — varchar(100)
  • cate_json — text
  • cate_od — int(20)

company (CopyOfUntitled)

  • Key (company_seq) — int(20) — Primary key — NOT NULL
  • Field2 (company_name) — varchar(100)
  • Field3 (company_biz) — varchar(300)
  • Field4 (company_user_seq) — int(20)
  • Field5 (company_addr1) — varchar(100)
  • Field6 (company_tel) — varchar(50)
  • Field7 (company_thumbnail) — varchar(100)
  • Field8 (company_dt_reg) — datetime

contractor (CopyOfCopyOfUntitled)

  • Key (contr_seq) — Primary key — NOT NULL
  • Field2 (contr_company_seq)
  • Field3 (contr_part)
  • Field4 (contr_writer)
  • Field5 (contr_company)
  • Field6 (contr_code)
  • Field7 (contr_location)
  • Field8 (contr_respon_person)
  • Field9 (contr_purpose)
  • Field10 (contr_respon_hp)
  • Field11 (contr_start_date)
  • Field12 (contr_end_date)

contractorUserInfo (CopyOfCopyOfCopyOfUntitled2)

  • Key (con_user_seq_seq) — Primary key — NOT NULL
  • Field2 (con_user_company_seq)
  • Field3 (con_user_cibtr_seq)
  • Field4 (con_user_name)
  • Field5 (con_user_gender)
  • Field6 (con_user_addr)
  • Field7 (con_user_security_number)
  • Field8 (con_user_hp)
  • Field9 (con_user_work_name)
  • Field10 (con_user_rams_number)
  • Field11 (con_user_dt_reg)

filedb (CopyOfCopyOfCopyOfUntitled22)

  • Key (file_seq) — Primary key — NOT NULL
  • Field7 (file_company_seq)
  • Field2 (file_gid)
  • Field3 (file_eid)
  • Field4 (file_name)
  • Field5 (file_real_name)
  • Field8 (file_path)

grade (CopyOfCopyOfUntitled3)

  • Key (grade_seq) — Primary key — NOT NULL
  • Field2 (grade_company_seq)
  • Field3 (grade_grade)
  • Field4 (grade_od)

meta (CopyOfCopyOfUntitled4)

  • Key (meta_seq) — Primary key — NOT NULL
  • Field2 (meta_user_seq)
  • Field3 (meta_company_seq)
  • Field4 (meta_json)
  • Field5 (meta_dt_reg)

team (CopyOfCopyOfUntitled2)

  • Key (team_seq) — Primary key — NOT NULL
  • Field2 (team_company_seq)
  • Field3 (team_depth)
  • Field4 (team_parent_depth)
  • Field5 (team_name)

user (CopyOfUntitled2)

  • Key (user_seq) — Primary key — NOT NULL
  • Field2 (user_id)
  • Field3 (user_name)
  • Field4 (user_pass)
  • Field5 (user_tel)
  • Field6 (user_tel_in)
  • Field7 (user_hp)
  • Field8 (user_email)
  • Field9 (user_dt_login)
  • Field10 (user_dt_reg)